FYI, found this one and it helps.
Now I have to figure out how to format it 'nicely' when you have a long string of sort for current_value so that it displays 'nicely'.
Will ask for help in the UNIX forum
https://www.christophermaier.name/2010/04/27/comparing-settings-from-different-postgresql-databases/
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@xxxxxxxxxx> 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');
--
Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
