By downloading you acknowledge and agree to the Crunchy Data Terms of Use and Data Collection Notice

  • 5.3.0-0
  • linux
  • amd64

PostGIS

Spatial and Geographic objects for PostgreSQL

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:ubi8-15.1-3.3-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

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:ubi8-15.1-3.3-0

Compressed Size: 1379.21