php mysql 网站模板,宁波市城市建设档案馆网站,dw班级网站建设,贵州省建设厅官网站2019独角兽企业重金招聘Python工程师标准 获取镜像#xff1a; docker pull mdillon/postgis 该 mdillon/postgis 镜像提供了容器中运行Postgres#xff08;内置安装PostGIS 2.5#xff09; 。该镜像基于官方 postgres image#xff0c;提供了多种变体#… 2019独角兽企业重金招聘Python工程师标准 获取镜像 docker pull mdillon/postgis 该 mdillon/postgis 镜像提供了容器中运行Postgres内置安装PostGIS 2.5 。该镜像基于官方 postgres image提供了多种变体包括 Postgres 9 支持的 (9.4-9.6), Postgres 10和Postgres 11。 该镜像保证由父 postgres image安装了如下的扩展 postgispostgis_topologyfuzzystrmatchpostgis_tiger_geocoder除非 -e POSTGRES_DB 参数在启动时传递该database将在admin用户后被命名 (要么是 postgres 或是通过 -e POSTGRES_USER指定)。 If you would prefer to use the older template database mechanism for enabling PostGIS, the image also provides a PostGIS-enabled template database called template_postgis. Usage In order to run a basic container capable of serving a PostGIS-enabled database, start a container as follows: docker run --name some-postgis -e POSTGRES_PASSWORDmysecretpassword -d mdillon/postgisFor more detailed instructions about how to start and control your Postgres container, see the documentation for the postgres image here. Once you have started a database container, you can then connect to the database as follows: docker run -it --link some-postgis:postgres --rm postgres \sh -c exec psql -h $POSTGRES_PORT_5432_TCP_ADDR -p $POSTGRES_PORT_5432_TCP_PORT -U postgresSee the PostGIS documentation for more details on your options for creating and using a spatially-enabled database. Known Issues / Errors When You encouter errors due to PostGIS update OperationalError: could not access file $libdir/postgis-X.X, run: docker exec some-postgis update-postgis.sh It will update to Your newest PostGIS. Update is idempotent, so it wont hurt when You run it more than once, You will get notification like: Updating PostGIS extensions template_postgis to X.X.X
NOTICE: version X.X.X of extension postgis is already installed
NOTICE: version X.X.X of extension postgis_topology is already installed
NOTICE: version X.X.X of extension postgis_tiger_geocoder is already installed
ALTER EXTENSION
Updating PostGIS extensions docker to X.X.X
NOTICE: version X.X.X of extension postgis is already installed
NOTICE: version X.X.X of extension postgis_topology is already installed
NOTICE: version X.X.X of extension postgis_tiger_geocoder is already installed
ALTER EXTENSION参考 https://hub.docker.com/r/mdillon/postgisPostgreSQL Kubernetes: How to run HA Postgres on Kuberneteshttps://portworx.com/ha-postgresql-kubernetes/ Deploying PostgreSQL Clusters using StatefulSetshttps://portworx.com/ha-postgresql-kubernetes/ Crunchy Container Suitehttps://github.com/CrunchyData/crunchy-containers 转载于:https://my.oschina.net/u/2306127/blog/2994106
