#记录在已运行postgres数据库容器安装扩展#
#已经创建的容器使用此方式,安装完成后docker commit转为镜像传入内网使用。也可Dockerfile创建。
--进入容器:
docker exec -it postgres-test /bin/bash #进入镜像命令
--更新apt-get源
1、备份原始的Ubuntu源列表
cp /etc/apt/sources.list /etc/apt/sources.list.backup
apt-get install -y vim
2、修改源列表文件(deb仓库源随时可能过期,自行寻找)
# vim /etc/apt/sources.list
deb https://mirrors.huaweicloud.com/ubuntu/ focal main restricted universe multiverse
deb https://mirrors.huaweicloud.com/ubuntu/ focal-security main restricted universe multiverse
deb https://mirrors.huaweicloud.com/ubuntu/ focal-updates main restricted universe multiverse
deb https://mirrors.huaweicloud.com/ubuntu/ focal-backports main restricted universe multiverse
deb https://mirrors.huaweicloud.com/debian/ bullseye main
deb https://mirrors.huaweicloud.com/debian/ bullseye-updates main
deb https://mirrors.huaweicloud.com/debian-security/ bullseye-security main
apt-get update
3、安装postgis#需要版本兼容性
apt-get install postgresql-14-postgis-3
4、客户端连接数据库执行以下命令
CREATE EXTENSION postgis;
----------------------Dockerfile方式安装postgis---------------------
#暂时没写