前提:安装好 docker 及 docker-compose
1、编写docker-compose.yml 文件
version: '3'
services:
pgsql:
image: postgres:14.8
container_name: pgsql
restart: always
environment:
POSTGRES_DB: charge
POSTGRES_USER: postgresql
POSTGRES_PASSWORD: charge0417@.+
TZ: Asia/Shanghai
PGDATA: /var/lib/postgresql/data/pgdata
ports:
- 5432:5432
volumes:
- /weio/devsoft/pgsql/data:/var/lib/postgresql/data/pgdata
- /weio/devsoft/pgsql/conf/postgresql.conf:/var/lib/postgresql/data/postgresql.conf
2、创建镜像并启动
docker-compose -f docker-compose.yml up -d
3、进入容器
docker exec -it pgsql /bin/sh
4、更新软件包
apt update
5、使用apt在线安装postgis
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-dbgsym postgresql-14-postgis-3-scripts
6、创建扩展并验证
使用客户端软件连接到 pgsql
6.1、创建EXTENSION
CREATE EXTENSION postgis;
6.2、验证,查看版本
SELECT postgis_full_version();
查询结果:
POSTGIS="3.4.2 c19ce56" [EXTENSION] PGSQL="140" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/lib/postgresql/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db" LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"