Should shared_preload_libraries be loaded during binary upgrade?

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Should shared_preload_libraries be loaded during binary upgrade?
Date: 2025-05-01 05:35:56
Message-ID: CAFiTN-vSqgk1zVbXArzUu7OyBDF6LK-uWynEyDgNe48L0=Y7RQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Does it make sense to load "shared_preload_libraries" during binary
upgrade mode?

An extension might unintentionally interfere with pg_upgrade, for
example, by connecting to the 'postgres' database, which can cause the
upgrade to fail as the restore needs to drop that database. While it's
true that extensions should ideally handle this themselves, wouldn't
it be safer if we could avoid loading them at all during the binary
upgrade mode?

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2025-05-01 06:15:00 Re: Introduce some randomness to autovacuum
Previous Message Junwang Zhao 2025-05-01 05:35:36 Re: Introduce some randomness to autovacuum