back to downloads

PostGIS

Spatial and Geographic objects for PostgreSQL

4.7.0
linux
amd64
View PostGIS documentation

Step 1

Set up key environmental variables for working with your container. This creates a user named hippo with a password of datalake that has access to a database named hippo:

cat << EOF > postgres-env.list
PG_MODE=primary
PG_PRIMARY_USER=postgres
PG_PRIMARY_PASSWORD=datalake
PG_DATABASE=hippo
PG_USER=hippo
PG_PASSWORD=datalake
PG_ROOT_PASSWORD=datalake
PG_PRIMARY_PORT=5432
EOF

Step 2

Run the container:

docker run --publish 5432:5432 \
  --volume=postgres:/pgdata \
  --env-file=postgres-env.list \
  --name="postgres" \
  --hostname="postgres" \
  --detach \
registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.1-4.7.0

Step 3

Connect to your database and start exploring!

PGPASSWORD=datalake psql -h localhost -p 5432 -U hippo hippo

You can verify that PostGIS is installed by executing the following command:

SELECT postgis_full_version();
TAGS:

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.0-4.7.0
COMPRESSED SIZE: 1209.51 MB

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.7-3.0-4.7.0
COMPRESSED SIZE: 1250.20 MB

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.7-2.5-4.7.0
COMPRESSED SIZE: 1245.83 MB

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.1-4.7.0
COMPRESSED SIZE: 1211.18 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.7-3.0-4.6.3
COMPRESSED SIZE: 2043.78 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.0-4.6.3
COMPRESSED SIZE: 2003.08 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.1-4.6.3
COMPRESSED SIZE: 2004.75 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.7-2.5-4.6.3
COMPRESSED SIZE: 2039.39 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.2-3.0-4.6.2
COMPRESSED SIZE: 1965.36 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.6-2.5-4.6.2
COMPRESSED SIZE: 2002.86 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.6-3.0-4.6.2
COMPRESSED SIZE: 2010.96 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.2-3.0-4.6.1
COMPRESSED SIZE: 1958.29 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.6-3.0-4.6.1
COMPRESSED SIZE: 2003.88 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.6-2.5-4.6.1
COMPRESSED SIZE: 1995.78 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.5-2.5-4.6.0
COMPRESSED SIZE: 1995.57 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.5-3.0-4.6.0
COMPRESSED SIZE: 2003.67 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.1-3.0-4.6.0
COMPRESSED SIZE: 1958.13 MB

4.5.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.7-2.5-4.5.3
COMPRESSED SIZE: 1964.62 MB

4.5.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-12.7-3.0-4.5.3
COMPRESSED SIZE: 1969.00 MB

4.5.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.0-4.5.3
COMPRESSED SIZE: 1928.39 MB