back to downloads

pgAdmin4

A PostgreSQL database management user interface for both your desktop and browser

4.7.3
linux
amd64
View pgAdmin4 documentation

Step 1

Create a network so that the PostgreSQL and pgAdmin4 containers can communicate with each other:

docker network create --driver bridge pgnetwork

Step 2

Set up key environmental variables for working with both of the containers. 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

cat << EOF > pgadmin-env.list
PGADMIN_SETUP_EMAIL=hippo
PGADMIN_SETUP_PASSWORD=datalake
SERVER_PORT=5050
EOF

Step 3

Run the containers container:

docker run --publish 5432:5432 \
  --volume=postgres:/pgdata \
  --env-file=postgres-env.list \
  --name="postgres" \
  --hostname="postgres" \
  --network="pgnetwork" \
  --detach \
registry.developers.crunchydata.com/crunchydata/crunchy-postgres:centos8-13.4-4.7.3

docker run --publish 5050:5050 \
  --volume=pgadmin4:/var/lib/pgadmin \
  --env-file=pgadmin-env.list \
  --name="pgadmin4" \
  --hostname="pgadmin4" \
  --network="pgnetwork" \
  --detach \
registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.4-4.7.3

Step 4

Go to http://localhost:5050 in your local browser. Log into pgAdmin4 with your credentials, which are hippo and datalake

Step 5

Go to Servers, right click, and select Add a New Server:

  • For name, type in hippo
  • Click on "Connection"
    • For hostname, use postgres
    • For port, use 5432
    • For username, use hippo
    • For password, use datalake
    • Click Save Password

Click "Save" at the bottom.

Step 6

You should now be connected. Continue to explore pgAdmin4!

TAGS:

4.7.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.8-4.7.3
COMPRESSED SIZE: 808.93 MB

4.7.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.4-4.7.3
COMPRESSED SIZE: 808.93 MB

4.7.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.8-4.7.2
COMPRESSED SIZE: 953.54 MB

4.7.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.4-4.7.2
COMPRESSED SIZE: 953.54 MB

4.7.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.3-4.7.1
COMPRESSED SIZE: 950.18 MB

4.7.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.7-4.7.1
COMPRESSED SIZE: 950.18 MB

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.7-4.7.0
COMPRESSED SIZE: 780.63 MB

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.3-4.7.0
COMPRESSED SIZE: 780.63 MB

4.6.4

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.4-4.6.4
COMPRESSED SIZE: 876.29 MB

4.6.4

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.8-4.6.4
COMPRESSED SIZE: 876.29 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.7-4.6.3
COMPRESSED SIZE: 704.17 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.3-4.6.3
COMPRESSED SIZE: 704.17 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.6-4.6.2
COMPRESSED SIZE: 680.55 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.2-4.6.2
COMPRESSED SIZE: 680.55 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.2-4.6.1
COMPRESSED SIZE: 674.43 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.6-4.6.1
COMPRESSED SIZE: 674.43 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.1-4.6.0
COMPRESSED SIZE: 674.27 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.5-4.6.0
COMPRESSED SIZE: 674.27 MB

4.5.4

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-12.8-4.5.4
COMPRESSED SIZE: 901.80 MB

4.5.4

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgadmin4:centos8-13.4-4.5.4
COMPRESSED SIZE: 901.80 MB