MIME-Version: 1.0
References: <7a2da2d7264c1b5f518bc78db5305866a0857461.camel@ageofdream.com>
In-Reply-To: <7a2da2d7264c1b5f518bc78db5305866a0857461.camel@ageofdream.com>
From: Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>
Date: Mon, 6 Jan 2025 09:10:06 +0530
Message-ID: 
 <CAMa=N=My=gq6nw+5RKUUFFHzaOQ0hqaPEwOHeF2HkYju70Acrw@mail.gmail.com>
Subject: Re: Questions about the Debian Package version of pgAdmin
To: Nick <lists2@ageofdream.com>
Cc: pgadmin-support@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000923ed8062b01648e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMa%3DN%3DMy%3Dgq6nw%2B5RKUUFFHzaOQ0hqaPEwOHeF2HkYju70Acrw%40mail.gmail.com>
Precedence: bulk

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

Hi,


On Sun, Jan 5, 2025 at 7:29=E2=80=AFAM Nick <lists2@ageofdream.com> wrote:

>
> I'm using the apt repository version for Debian 12 (Bookworm). I'm also
> using Ansible to manage the server, and I have some questions about the
> pgAdmin Debian package version.
>
> 1. If we're using the pgAdmin DEB repo, will `apt-update` always update
> pgAdmin to the latest major version? ie. Will we be doing an upgrade
> every four weeks?
>
Yes. New pgadmin version is generally released every four weeks.


>
> 2. Should `sudo /usr/pgadmin4/bin/setup-web.sh` be run every time `apt-
> update` runs, or only once?
>
>
You need to run after every update.


> 3. Since the package is also installing Apache for us and configuring
> it, is there a safe way for us to modify the Apache config without
> breaking updates?
>

You can modify the Apache config using pgadmin4.conf. Upgrade does not
override the changes done by user.


> We'd like to enable TLS for Apache, but in a way that each time the
> playbook runs, it updates the pgAdmin package to the latest version,
> hopefully without breaking anything.
>
> Thanks,
> Nick
>

Thanks,
Yogesh Mahajan
EnterpriseDB

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

<div dir=3D"ltr"><div dir=3D"ltr"><div><div style=3D"font-family:verdana,sa=
ns-serif;font-size:small" class=3D"gmail_default">Hi,</div><div style=3D"fo=
nt-family:verdana,sans-serif;font-size:small" class=3D"gmail_default"><br><=
/div><div style=3D"font-family:verdana,sans-serif;font-size:small" class=3D=
"gmail_default"><br></div></div></div><br><div class=3D"gmail_quote gmail_q=
uote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Jan 5, 2025 a=
t 7:29=E2=80=AFAM Nick &lt;<a href=3D"mailto:lists2@ageofdream.com">lists2@=
ageofdream.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:sol=
id;border-left-color:rgb(204,204,204);padding-left:1ex"><br>
I&#39;m using the apt repository version for Debian 12 (Bookworm). I&#39;m =
also<br>
using Ansible to manage the server, and I have some questions about the<br>
pgAdmin Debian package version.<br>
<br>
1. If we&#39;re using the pgAdmin DEB repo, will `apt-update` always update=
<br>
pgAdmin to the latest major version? ie. Will we be doing an upgrade<br>
every four weeks?<br></blockquote><div><div style=3D"font-family:verdana,sa=
ns-serif;font-size:small" class=3D"gmail_default"></div><div style=3D"font-=
family:verdana,sans-serif;font-size:small" class=3D"gmail_default">Yes. New=
 pgadmin version is generally released every four weeks.</div><br></div><di=
v>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(=
204,204,204);padding-left:1ex">
<br>
2. Should `sudo /usr/pgadmin4/bin/setup-web.sh` be run every time `apt-<br>
update` runs, or only once?<br>
<br></blockquote><div>=C2=A0</div><div><div style=3D"font-family:verdana,sa=
ns-serif;font-size:small" class=3D"gmail_default">You need to run after eve=
ry update.</div><br></div><div>=C2=A0</div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style=
:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
3. Since the package is also installing Apache for us and configuring<br>
it, is there a safe way for us to modify the Apache config without<br>
breaking updates?<br></blockquote><div>=C2=A0</div><div><div style=3D"font-=
family:verdana,sans-serif;font-size:small" class=3D"gmail_default">You can =
modify the Apache config using pgadmin4.conf. Upgrade does not override the=
 changes done by user.</div></div><div><br></div><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left=
-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<br>
We&#39;d like to enable TLS for Apache, but in a way that each time the<br>
playbook runs, it updates the pgAdmin package to the latest version,<br>
hopefully without breaking anything.<br>
<br>
Thanks,<br>
Nick<br></blockquote><div><br></div><font face=3D"verdana, sans-serif">Than=
ks,</font><div><font face=3D"verdana, sans-serif">Yogesh Mahajan</font></di=
v><div><span style=3D"font-family:verdana,sans-serif">EnterpriseDB</span>=
=C2=A0</div></div></div>

--000000000000923ed8062b01648e--