cannot start pgAdmin container with external database for pgAdmin user settings

[aremund]

cannot start pgAdmin container with external database for pgAdmin user settings

[mitchellkellett]

I had this issue too when I tried a fresh install of 8.8. I ended up installing 8.6. Then migrating to 8.8.

Mine didn't want to create anything, from memory it wanted to start the db migrations with an update to preferences.

[yogeshmahajan-1903]

@aremund
Are you updating(specifically from 8.7 to 8.8) existing pgadmin app or doing fresh install? Are using secrets to provide PGADMIN_DEFAULT_EMAIL, PGADMIN_DEFAULT_PASSWORD?

[aremund]

@yogeshmahajan-1903 I wanted to migrate to an external database for our existing installation (8.8) and added the PGADMIN_CONFIG_CONFIG_DATABASE_URI for our existing Installation.
Since this did not work, I tried it with a new installation and reported the ticket based on a new installation.
Yes, I use a secret for PGADMIN_DEFAULT_EMAIL, PGADMIN_DEFAULT_PASSWORD.

[yogeshmahajan-1903]

@aremund
Can you please check you secrets, I am doubting error is because empty secrets. Or May be just try directly passing PGADMIN_DEFAULT_EMAIL, PGADMIN_DEFAULT_PASSWORD just for test. I am not able to reproduce the issue , but I do not use secrets.

[sdsys-ch]

I ran into the same issue today on a fresh install with 8.8. Environment was

Docker version 25.0.1, build 29cf629
Docker Compose version v2.24.2

Environment via docker compose env_file: .env.pgadmin statement:

PGADMIN_DEFAULT_EMAIL=--redacted--
PGADMIN_DEFAULT_PASSWORD=--redacted--
PGADMIN_DISABLE_POSTFIX=True
PGADMIN_CONFIG_APP_NAME="'... PGAdmin'"
PGADMIN_CONFIG_LANGUAGES="{'en': 'English', 'de': 'German', 'fr': 'French'}"
PGADMIN_CONFIG_DEFAULT_SERVER_PORT=80
PGADMIN_CONFIG_LOGIN_BANNER="'...'"
PGADMIN_CONFIG_DEBUG=False
PGADMIN_CONFIG_CONFIG_DATABASE_URI="'postgresql://pgadm_usr:--redacted--@db_srv:5432/pgadmin'"
PGADMIN_CONFIG_MAIL_SERVER="'...'"
PGADMIN_CONFIG_MAIL_PORT=587
PGADMIN_CONFIG_MAIL_SSL=False
PGADMIN_CONFIG_MAIL_TLS=True
PGADMIN_CONFIG_MAIL_USERNAME="'...'"
PGADMIN_CONFIG_MAIL_PASSWORD="'...'"
PGADMIN_CONFIG_SECURITY_EMAIL_SENDER="'...'"
PGADMIN_CONFIG_SESSION_EXPIRATION_TIME=5

Workaround by @mitchellkellett did the trick here as well. Thanks @mitchellkellett !

[pravesh-sharma]

Issue fixed. Verified on docker snapshot image.