Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUddd-001YYs-OI for pgsql-general@arkaria.postgresql.org; Mon, 06 Jan 2025 03:18:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tUddc-004fse-U1 for pgsql-general@arkaria.postgresql.org; Mon, 06 Jan 2025 03:18:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUddc-004fn9-J8 for pgsql-general@lists.postgresql.org; Mon, 06 Jan 2025 03:18:44 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUdda-0005HQ-0w for pgsql-general@lists.postgresql.org; Mon, 06 Jan 2025 03:18:43 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-29fcbf3d709so4653154fac.2 for ; Sun, 05 Jan 2025 19:18:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736133522; x=1736738322; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=ZNa8TdZqnNHLrV36Lt7koDapjIF+W7McB2+AMybZLMw=; b=LRTeMFuCLhQRi1+EQOZs1ZDAJwQsuhqQGBV3wOh5NxgpBnwENzYhh2LEaql57vaeHM BUWv567JmcEeRpfwTsOaLB/5jTDPLeSMdBPSQY9t9slLNLydyfNDqVyv73uAkyvyRpf/ Nqiqz9xyiFL6dd3MZrKJvtrxtge3Wio4xKKJIIuVY6p0EcwP8s9UpF0CgBEuayrs2l7F caqx/pHL9aErAqDrJqrbE6zVDfGmx3Wb+hNOi0RkbAjIUfmQ+kpYgl15m0/lpkWc5tK2 gJId1R0w7KRbm+7s6an4vNSmWrL1j32fk8YmU+R2hpxTN5cnQfhNkJL2KzkTSo0UKI8r OlOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736133522; x=1736738322; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ZNa8TdZqnNHLrV36Lt7koDapjIF+W7McB2+AMybZLMw=; b=jXS3DUhEGlBA0xvsmc35gvaTMR1AjaZ9GygwmOQwCz8HuOI/kkqIKtlaaPf8UlFo3g dZ8onIHTzDCEXhPJM7MjvgjFm8wCYnCFYTWVZkZRHpTXcS+yVy0Sup+AX5e+TUs/FNrS EhOkj0qvVJji1L3jmTTzYayAQzO6QWg4k+04B85FWuPXsVU5sKXpv6oFsQm6/gD7a+N3 K3TBcHLarrf44hNAmYGessB6vtRFaVn/jWn4ba6EpsP5zTVZxklWthy3BUI/SjOIP7wc HTN1ZKWGEaShODAZ/W6dlkLvwPcH0QtFGCG0/+gi6cyeZVIEsE0kPMvhGIkEyNZjLshE HQhg== X-Gm-Message-State: AOJu0YzMdJ2pCkix6M5KCMfAN0hv8YuJkgA7avtYJlHm6JH52aQMYLAg CEmcjN7xEl54ny+R0Te+6xBoXgnbW45dFlbCQ4+dM5H0Jl8jfr2fF+FiFsExPY4+dlfwAwrATVA aXiSyp8tyOPgd4p/tdPf0Q7GhEqh9gQ== X-Gm-Gg: ASbGncueZDFxITuKjwUqyusYoFU4S52GCklYmjkOyo96POov91FEMhY6dkiCwwb43rz kaD8PJEJXemxk7VNAHjv1G3rOaX+Io/DgAMbvy6M= X-Google-Smtp-Source: AGHT+IE9NRU0IuQW/c0+T7afaA2c1mfy6BSnZ3NWn4RxDHBIWzTql8Zg6HP0Cc65jRwOJjWsoRctrJK+dupbhMhw69Y= X-Received: by 2002:a05:6870:e07:b0:296:aef8:fe9a with SMTP id 586e51a60fabf-2a7fafffae5mr28546635fac.7.1736133521735; Sun, 05 Jan 2025 19:18:41 -0800 (PST) MIME-Version: 1.0 References: <76354c477f2636a93d891528b66c5b8c6d6b1db5.camel@ageofdream.com> In-Reply-To: <76354c477f2636a93d891528b66c5b8c6d6b1db5.camel@ageofdream.com> From: Ron Johnson Date: Sun, 5 Jan 2025 22:18:30 -0500 Message-ID: Subject: Re: Questions about the Debian Package version of pgAdmin To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000d886f8062b0115f3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d886f8062b0115f3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Jan 5, 2025 at 7:27=E2=80=AFPM 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? > 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 > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000d886f8062b0115f3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Jan 5, 2025 at 7:27=E2=80=AFPM Ni= ck <lists2@ageofdream.com&g= t; 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 r= epos never=C2=A0(well, very very rarely) upgrade the version.=C2=A0 = It's always bug fixes, and why Stable software can get soooo old.
=
=C2=A0
2. Shoul= d `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.
=C2=A0<= /div>
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&= #39;m still alive.
<Redacted> lobster!
=
--000000000000d886f8062b0115f3--