Postgres upgrade from 13 to 16?
Hi folks, we're running a decent-sized MM3 server backed by a Postgres database server that is also used by a number of other applications. It's currently running Postgres 13, and we are looking at upgrading to 16.
Can anyone tell me what the implications of such an upgrade be in the context of Mailman3? Any gotchas?
Thanks,
-Dave-- Dave McGuire, AK4HZ New Kensington, PA
Dave McGuire writes:
Hi folks, we're running a decent-sized MM3 server backed by a Postgres database server that is also used by a number of other applications. It's currently running Postgres 13, and we are looking at upgrading to 16.
Pretty sure there was an authn/authz-related issue somewhere around Postgres 14. It's well-documented on the site, it just bit me on a Debian update. I no longer have access to that host so I don't recall what it was, just that it threw a clear error, and a little web search pointed directly to several useful articles on the PostgreSQL site. One of them was specifically about upgrading from v.X to v.(X+1).
-- GNU Mailman consultant (installation, migration, customization) Sirius Open Source https://www.siriusopensource.com/ Software systems consulting in Europe, North America, and Japan
On Sun, Sep 14, 2025 at 12:39 AM Dave McGuire <mcguire@neurotica.com> wrote:
Hi folks, we're running a decent-sized MM3 server backed by a Postgres database server that is also used by a number of other applications. It's currently running Postgres 13, and we are looking at upgrading to 16.
Can anyone tell me what the implications of such an upgrade be in the context of Mailman3? Any gotchas?
https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public...
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]
On 9/14/25 06:15, Odhiambo Washington via Mailman-users wrote:
Hi folks, we're running a decent-sized MM3 server backed by aPostgres database server that is also used by a number of other applications. It's currently running Postgres 13, and we are looking at upgrading to 16.
Can anyone tell me what the implications of such an upgrade be in thecontext of Mailman3? Any gotchas?
https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public...
Got it, thanks Odhiambo and Steve. I appreciate your help.
-Dave-- Dave McGuire, AK4HZ New Kensington, PA
participants (3)
-
Dave McGuire -
Odhiambo Washington -
Stephen J. Turnbull