postgis-docker

4.postgis
### postgis
### postgis
docker pull postgis/postgis:12-3.1-alpine
docker run -t --name postgresql --restart always  -e POSTGRES_USER='postgres' -e POSTGRES_PASSWORD=JsoSVUhhrXHqksSE -e ALLOW_IP_RANGE=0.0.0.0/0 -p 7803:5432 -d postgis/postgis:12-3.1-alpine

postgres=# CREATE DATABASE "ez-datamanagement";
CREATE DATABASE
postgres=# \c "ez-datamanagement"
You are now connected to database "ez-datamanagement" as user "postgres".
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_raster;
CREATE EXTENSION postgis_sfcgal;
CREATE EXTENSION fuzzystrmatch; --needed for postgis_tiger_geocoder
--optional used by postgis_tiger_geocoder, or can be used standalone
CREATE EXTENSION address_standardizer;
CREATE EXTENSION address_standardizer_data_us;
CREATE EXTENSION postgis_tiger_geocoder;
CREATE EXTENSION postgis_topology;

CREATE USER water_platform_rw WITH PASSWORD 'JsoSVUhhrXHqksSE';
create database "ez-datamanagement" owner water_platform_rw;


数据库更新：
postgis：
db:  172.122.11.205
backdb:  172.28.12.135 nohup  sh export_project_503.sh  &
restoredb: 
172.122.11.205    
docker cp jinan.sql postgresql:/

postgres=# select * from pg_stat_activity where datname='ez-datamanagement';
postgres=# DROP DATABASE "ez-datamanagement";
DROP DATABASE


# 额外开一个终端恢复，否则会报错
[root@mysql-slaver--postgres-master ~]# docker exec -it postgresql sh
/ # su - postgres
5746a0105214:~$ psql
psql (12.9)
Type "help" for help.
postgres=#


postgres=# CREATE DATABASE "ez-datamanagement";
CREATE DATABASE
postgres=# \c "ez-datamanagement"
You are now connected to database "ez-datamanagement" as user "postgres".
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_raster;
CREATE EXTENSION postgis_sfcgal;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION address_standardizer_data_us;
CREATE EXTENSION postgis_tiger_geocoder;
CREATE EXTENSION postgis_topology;

psql -U postgres -w  < /jinan.sql; 

 export PGPASSWORD=Z4vQ92yQIkuN
psql -U postgres -h 172.122.11.205 -p 7802 -w  < jinan_postgresql.sql