Re: Comparing Parameters PRE- and POST- Upgrade - Any script?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Mar 5, 2025, at 2:18 PM, Edwin UY <edwin.uy@xxxxxxxxx> wrote:
> 
> Thanks, I thought pg_upgrade will somehow insert/update it with new parameters of sorts.

No. So you wind up with new parameters just getting defaults, and not specified or documented in the file.

Couple of ways around this:

- Put your parameters in a separate file that's included into postgresql.conf.
- Generate a new db, diff its config against the old one to see what's new that you might want to change, and use it with the inclusion of your settings.





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux