Re: pgAdmin web crashes on start with external DB

Hi,

On Tue, Nov 5, 2024 at 11:07 PM Maurice Lajoie <moelaj(at)runbox(dot)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.
Ref: https://www.pgadmin.org/docs/pgadmin4/8.12/container_deployment.html

> 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(at)postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77(dot)cmqeanecqlnd(dot)ca-central-1(dot)rds(dot)amazonaws(dot)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
>