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

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Дата
Msg-id 5E4F62CA-BFEA-4F54-B1CB-F47D23CA32E1@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Comparing Parameters PRE- and POST- Upgrade - Any script?  (Edwin UY <edwin.uy@gmail.com>)
Список pgsql-admin
> On Mar 5, 2025, at 2:18 PM, Edwin UY <edwin.uy@gmail.com> 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
withthe inclusion of your settings. 


В списке pgsql-admin по дате отправления: