P.S.: darn it, I need a new job remotely to get more skills :( paid/unpaid just to get ore real more interesting experience
On Wed, Mar 19, 2025 at 9:46 AM Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Mar 5, 2025 at 04:24:24PM -0500, Ron Johnson wrote: > The default postgresql.conf file might change across versions. > > I remove everything from postgresql except for site-specific customizations, > and copy those and pg_hba.conf over. > > There's certainly no harm in doing "SELECT name, setting, unit FROM pg_settings > ORDER BY name;" on the old instance, and then on the new instance after it's > properly configured.
You can query just the changed values with:
SELECT name, current_setting(name), source FROM pg_settings WHERE source NOT IN ('default', 'override');
