PostgreSQL pgAdmin 4 with binary support
docker run -d --name pgadmin -p 5433:80 foxylion/pgadmin4
Now you can access your pgAdmin instance on localhost:5433.
|SERVER_MODE||When set to true authentification is required to acces pgAdmin 4||
|MAIL_SERVER||Mail server for sending mails (e.g. forgotten passwords)||
|MAIL_PORT||Mail server port||
|MAIL_USE_SSL||When enabled ssl is used to connect to the mail server||
|MAIL_USERNAME||Username used to authenticate against the mail server||
|MAIL_PASSWORD||Password used to authenticate against the mail server||
Binary Support (pg_dump, pg_restore)
This version of pgAdmin 4 brings the binaries required to backup/restore databases
with it. You can do backups of PostgreSQL 9.5 servers.
To enable the feature go to File -> Preferences -> Binary paths and set them to
When doing a backup it is recommended to setup a directory where the backups can
be stored outside of the container.
Data Storage Outside of the Container
-v /my/local/directory:/data to the
docke run command. This will store
the session and configuration database in the mounted folder. The storage is also there.
Finally I succeeded in running the container : interactive shell was missing for the first run.
So don't forget '-t -i' parameters when executing docker run!
Actually it was a SELinux issue : running volume with :Z fixes the permission rights -v /my/local/directory:/data:Z.
However, I got this issue now :
pgAdmin 4 - Application Initialisation
Traceback (most recent call last):
File "./usr/local/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py", line 41, in <module>
File "<string>", line 469, in <module>
File "<string>", line 83, in do_setup
EOFError: EOF when reading a line
This is exactly what I was looking for, thanks !
Just one question : how do you manage the permission issue when a volume is mounted to store the pgadmin db ?
It seams that it requires www-data user while the volume is owned by root