Public | Automated Build

Last pushed: 2 months ago
Short Description
PostgreSQL pgAdmin 4 with binary support (backup, restore, ...)
Full Description

PostgreSQL pgAdmin 4 with binary support

Quick Start

docker run -d --name pgadmin -p 5433:80 foxylion/pgadmin4

Now you can access your pgAdmin instance on localhost:5433.

Environment Variables

Variable Name Description Default
SERVER_MODE When set to true authentification is required to acces pgAdmin 4 False
MAIL_SERVER Mail server for sending mails (e.g. forgotten passwords) mail.example.tld
MAIL_PORT Mail server port 465
MAIL_USE_SSL When enabled ssl is used to connect to the mail server True
MAIL_USERNAME Username used to authenticate against the mail server username
MAIL_PASSWORD Password used to authenticate against the mail server password

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 /usr/bin.

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

Just pass -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.

Docker Pull Command
Source Repository

Comments (3)
5 months ago

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!

5 months ago

Hi Again!
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/", line 41, in <module>
exec(open(file_quote(setupfile), 'r').read())
File "<string>", line 469, in <module>
File "<string>", line 83, in do_setup
EOFError: EOF when reading a line

Any ideas?

5 months ago

Hi !
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