Thread: Questions about the Debian Package version of pgAdmin

Questions about the Debian Package version of pgAdmin

From
Nick
Date:
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








Re: Questions about the Debian Package version of pgAdmin

From
Ron Johnson
Date:
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!

Re: Questions about the Debian Package version of pgAdmin

From
Nick
Date:
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.







Re: Questions about the Debian Package version of pgAdmin

From
Adrian Klaver
Date:
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