public inbox for [email protected]  

help / color / mirror / Atom feed

From: Khushboo Vashi <[email protected]>
To: Maurice Lajoie <[email protected]>
Cc: pgadmin-support <[email protected]>
Subject: Re: pgAdmin web crashes on start with external DB
Date: Wed, 6 Nov 2024 10:42:07 +0530
Message-ID: <CAFOhELc8FTReBG3JNCziZ++X0YnXJ7KiEv_Joe386mMANKgPpA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Hi,

On Tue, Nov 5, 2024 at 11:07 PM Maurice Lajoie <[email protected]> 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@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
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pgAdmin web crashes on start with external DB
  In-Reply-To: <CAFOhELc8FTReBG3JNCziZ++X0YnXJ7KiEv_Joe386mMANKgPpA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox