MIME-Version: 1.0
References: <E1t8NU8-0003ds-Sf@rmmprod06.runbox>
In-Reply-To: <E1t8NU8-0003ds-Sf@rmmprod06.runbox>
From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Date: Wed, 6 Nov 2024 10:42:07 +0530
Message-ID: 
 <CAFOhELc8FTReBG3JNCziZ++X0YnXJ7KiEv_Joe386mMANKgPpA@mail.gmail.com>
Subject: Re: pgAdmin web crashes on start with external DB
To: Maurice Lajoie <moelaj@runbox.com>
Cc: pgadmin-support <pgadmin-support@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e58a8b0626378f87"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFOhELc8FTReBG3JNCziZ%2B%2BX0YnXJ7KiEv_Joe386mMANKgPpA%40mail.gmail.com>
Precedence: bulk

--000000000000e58a8b0626378f87
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

On Tue, Nov 5, 2024 at 11:07=E2=80=AFPM 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=E2=80=99m assuming it=E2=80=99s using SQLite which would not be p=
ersistent 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-4=
cef636bcf77.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 tex=
t
> with =E2=80=9Cxxx=E2=80=9D 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
>

--000000000000e58a8b0626378f87
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi,</div><br><div class=3D"gmail_quote"><=
div dir=3D"ltr" class=3D"gmail_attr">On Tue, Nov 5, 2024 at 11:07=E2=80=AFP=
M Maurice Lajoie &lt;<a href=3D"mailto:moelaj@runbox.com">moelaj@runbox.com=
</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
Hi,<br>
I successfully deployed pgAdmin web on our SAP BTP Cloud Foundry and can ac=
cess pgAdmin and logon.<br>
I can create users and servers but when the app restarts, all entries are l=
ost. I=E2=80=99m assuming it=E2=80=99s using SQLite which would not be pers=
istent in the Cloud Foundry.<br></blockquote><div>You can map the pgAdmin D=
ata directory to the outside container, so it can persist the SQLite and ot=
her data.=C2=A0</div><div>Ref:=C2=A0<a href=3D"https://www.pgadmin.org/docs=
/pgadmin4/8.12/container_deployment.html">https://www.pgadmin.org/docs/pgad=
min4/8.12/container_deployment.html</a></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex">
I did bind web-pgadmin to a PostgreSQL, Hyperscaler Option database.<br>
<br>
I added the user-provided variable to PGADMIN_CONFIG_CONFIG_DATABASE_URI wi=
th:<br>
postgres://<a href=3D"http://xxxxxxxxxxxxx:ff855340a50467bb21ebd99@postgres=
-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cmqeanecqlnd.ca-central-1.rds.amazon=
aws.com:1831/xxDB-Namexx" rel=3D"noreferrer" target=3D"_blank">xxxxxxxxxxxx=
x:ff855340a50467bb21ebd99@postgres-xxxxxxxxx-f2a1-45c2-9e9d-4cef636bcf77.cm=
qeanecqlnd.ca-central-1.rds.amazonaws.com:1831/xxDB-Namexx</a></blockquote>=
<div>Please refer to=C2=A0<a href=3D"https://www.pgadmin.org/docs/pgadmin4/=
latest/external_database.html">https://www.pgadmin.org/docs/pgadmin4/latest=
/external_database.html</a> for the correct variable value.</div><div><br><=
/div><div>Thanks,</div><div>Khushboo</div><div>=C2=A0</div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex"><br>
<br>
I restarted the pgadmin-web app and it crashed.<br>
<br>
Please find attached the application start log. I changed some of the text =
with =E2=80=9Cxxx=E2=80=9D for security.<br>
<br>
For the deployment, I used a docker image:<br>
applications:<br>
=C2=A0 - name: pgadmin-web<br>
=C2=A0 =C2=A0 docker:<br>
=C2=A0 =C2=A0 =C2=A0 image: dpage/pgadmin4:2024-10-19-2<br>
=C2=A0 =C2=A0 instances: 1<br>
=C2=A0 =C2=A0 memory: 1G<br>
=C2=A0 =C2=A0 disk_quota: 1G<br>
=C2=A0 =C2=A0 health-check-type: process<br>
=C2=A0 =C2=A0 env:<br>
=C2=A0 =C2=A0 =C2=A0 PGADMIN_DEFAULT_EMAIL: &lt;email address&gt;<br>
=C2=A0 =C2=A0 =C2=A0 PGADMIN_DEFAULT_PASSWORD: &lt;new password&gt;<br>
=C2=A0 =C2=A0 =C2=A0 PGADMIN_LISTEN_ADDRESS: 0.0.0.0<br>
<br>
Thank you<br>
Moelaj<br>
</blockquote></div></div>

--000000000000e58a8b0626378f87--