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
Owner
foxylion
Source Repository

Comments (3)
cballagny
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!

cballagny
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/pgAdmin4.py", 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?
Thanks!

cballagny
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