Thread: Questions about the Debian Package version of pgAdmin
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? 2. Should `sudo /usr/pgadmin4/bin/setup-web.sh` be run every time `apt- update` runs, or only once? 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
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