Thread: Re: pgAdmin web crashes on start with external DB
Hi,
On Tue, Nov 5, 2024 at 11:07 PM Maurice Lajoie <moelaj@runbox.com> wrote:
Hi,
I successfully deployed pgAdmin web on our SAP BTP Cloud Foundry and can access pgAdmin and logon.
I can create users and servers but when the app restarts, all entries are lost. I’m assuming it’s using SQLite which would not be persistent in the Cloud Foundry.
You can map the pgAdmin Data directory to the outside container, so it can persist the SQLite and other data.
I did bind web-pgadmin to a PostgreSQL, Hyperscaler Option database.
I added the user-provided variable to PGADMIN_CONFIG_CONFIG_DATABASE_URI with:
postgres://xxxxxxxxxxxxx:ff855340a50467bb21ebd99@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx
Please refer to https://www.pgadmin.org/docs/pgadmin4/latest/external_database.html for the correct variable value.
Thanks,
Khushboo
I restarted the pgadmin-web app and it crashed.
Please find attached the application start log. I changed some of the text with “xxx” for security.
For the deployment, I used a docker image:
applications:
- name: pgadmin-web
docker:
image: dpage/pgadmin4:2024-10-19-2
instances: 1
memory: 1G
disk_quota: 1G
health-check-type: process
env:
PGADMIN_DEFAULT_EMAIL: <email address>
PGADMIN_DEFAULT_PASSWORD: <new password>
PGADMIN_LISTEN_ADDRESS: 0.0.0.0
Thank you
Moelaj