philnc/pgadmin4 repository overview

My own image of the web gui for PostgreSQL, based on fenglc/pgadmin4. Not recommended for anyone else.

Docker run script:

docker run --name pgadmin4 \
-p 5050:5050 \
-d fenglc/pgadmin4

Using this image can be tricky unless you're careful to properly configure the PostgreSQL server to be managed, including any host firewall (and SELinux!).

On Ubuntu 16.04 LTS I use ufw and simply allow 1433 from all hosts.

ufw allow 5050

My postgresql.conf is set to:

listen_addresses = '*'

and my pg_hba.conf has a couple of extra lines at the bottom to allow IPv4 connections both from the internal docker network (where pgadmin4 runs) and my home subnet (because I like to work from a laptop downstairs in the TV room):

# IPv4 remote connections
host    all         all             10.12.0.0/24             md5
host    all         all             172.17.0.0/16           md5

When setting up server profiles in pgadmin the SSL tab will default to "Prefer", unless you really know what you're doing I'd recommend setting it to "Allow" instead.

I also changed the pgadmin user to "dba@home" and gave it a secure password, and then removed the default user.

This is probably not how I'd do things in production, but I think it is good enough for home or a lab environment.