pgadmin.md

pgAdmin

Some notes on dpage/pgadmin4 images.

The full documentation is here.

Table of Contents

• pgAdmin
  • Table of Contents
  • Essential environment variables
  • Removing login screen
  • Removing master password
  • Adding servers

Essential environment variables

PGADMIN_DEFAULT_EMAIL: '[email protected]'
PGADMIN_DEFAULT_PASSWORD: 'password'

Removing login screen

The pgAdmin container comes with a login screen by default, this can by bypassed by setting the following enviroment variables:

PGADMIN_CONFIG_SERVER_MODE: 'False'

Removing master password

The pgAdmin container comes with a master password by default, this can by bypassed by setting the following enviroment variables:

PGADMIN_CONFIG_MASTER_PASSWORD_REQUIRED: 'False'

Adding servers

Servers can be added by overridding the servers.json file at /pgadmin4/servers.json with:

{
    "Servers": {
        "1": {
            "Name": "Server Name",
            "Group": "Servers",
            "Port": 5432,
            "Username": "postgres",
            "Host": "db",
            "MaintenanceDB": "postgres",
            "SSLMode": "prefer",
            "PassFile": "/pgpass" // Omit if not using password authentication
        }
    }
}

If you are using password authentication, you will need to mount a pgpass file into the container at /pgpass with the following format:

# hostname:port:database:username:password
db:5432:postgres:postgres:postgres