From: | "Maurice Lajoie" <moelaj(at)runbox(dot)com> |
---|---|
To: | "pgadmin-support" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | pgAdmin web crashes on start with external DB |
Date: | 2024-11-05 17:36:56 |
Message-ID: | E1t8NU8-0003ds-Sf@rmmprod06.runbox |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
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
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
Attachment | Content-Type | Size |
---|---|---|
pgadmin-web-2024-11-05 13_06_50.221+0000.txt | text/plain | 11.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Duncan | 2024-11-05 18:35:21 | Feature request - Pg 17 builtin locale provider |
Previous Message | pras kumpati | 2024-11-05 14:45:10 | Re: Unable to use pgAdmin in Browser |