Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAdmin web crashes on start with external DB - Mailing list pgadmin-support

From Khushboo Vashi
Subject Re: pgAdmin web crashes on start with external DB
Date
Msg-id CAFOhELc8FTReBG3JNCziZ++X0YnXJ7KiEv_Joe386mMANKgPpA@mail.gmail.com
Whole thread Raw
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: Darren Duncan
Date:
Subject: Feature request - Pg 17 builtin locale provider
Next
From: Akshay Joshi
Date:
Subject: Re: Feature request - Pg 17 builtin locale provider