Questions about the Debian Package version of pgAdmin

On Sun, Jan 5, 2025 at 7:27 PM Nick <lists2@ageofdream.com> wrote:

I sent this to the PgAdmin list but didn't get any replies. Not sure
how many people are on that list, but since these questions are general
enough, I figure someone on the main list will know:

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?

Debian's Stable repos *never* (well, very very rarely) upgrade the
version. It's always bug fixes, and why Stable software can get soooo old.

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

I doubt it, since you're not setting things up just for a patch.

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?

We'd like to enable TLS for Apache, but in a way that doesn't break
anything each time the setup playbook runs and updates PgAdmin.

Thanks,
Nick

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

On Sun, 2025-01-05 at 22:18 -0500, Ron Johnson wrote:

On Sun, Jan 5, 2025 at 7:27 PM Nick <lists2@ageofdream.com> wrote:

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?

Debian's Stable repos never (well, very very rarely) upgrade the
version.  It's always bug fixes, and why Stable software can get
soooo old.
 

This was in reference to the PgAdmin repository, not the official
Debian package repository. I didn't know if the PgAdmin repo
maintainers followed the same rule of one major version of PgAdmin per
version of Debian, or if the PgAdmin repo was always the latest
version, since PgAdmin only supports rolling releases.

On 1/5/25 16:27, Nick wrote:

I sent this to the PgAdmin list but didn't get any replies. Not sure
how many people are on that list, but since these questions are general
enough, I figure someone on the main list will know:

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?

From here:

https://www.pgadmin.org/download/pgadmin-4-apt/

Platform Architecture First supported release Last supported
Debian 12 (Bookworm) x86_64 7.0 -

So yes it will continue to be updated as long as Debian 12 is current.

I use Ubuntu 22.04 and pgAdmin regularly updates/upgrades.

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

I have never run it after the first download.

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?

I have never gone that deep into it as I rarely use pgAdmin.

We'd like to enable TLS for Apache, but in a way that doesn't break
anything each time the setup playbook runs and updates PgAdmin.

Thanks,
Nick

--
Adrian Klaver
adrian.klaver@aklaver.com