Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
| От | Ron Johnson |
|---|---|
| Тема | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |
| Дата | |
| Msg-id | CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? (Edwin UY <edwin.uy@gmail.com>) |
| Ответы |
Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
|
| Список | pgsql-admin |
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.
On Wed, Mar 5, 2025 at 4:19 PM Edwin UY <edwin.uy@gmail.com> wrote:
Thanks, I thought pg_upgrade will somehow insert/update it with new parameters of sorts.On Thu, Mar 6, 2025 at 10:03 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Mar 5, 2025 at 3:55 PM Edwin UY <edwin.uy@gmail.com> wrote:Hi,Does anyone know of a script that can be used to compare parameters pre- and post- upgrade?Is it something that's worth the effort though? Or is it not something to be worrying about?We only need to check pg_settings for this, is that correct?pg_upgrade?If you copy the old $PGDATA/postgresql.conf to the new $PGDATA directory, then your config parameters will all be the same.--Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-admin по дате отправления: