| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |
| Date: | 2025-03-05 21:24:24 |
| Message-ID: | CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)uy(at)gmail(dot)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(at)gmail(dot)com>
> wrote:
>
>> On Wed, Mar 5, 2025 at 3:55 PM Edwin UY <edwin(dot)uy(at)gmail(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios - cloud | 2025-03-06 08:28:00 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |
| Previous Message | Scott Ribe | 2025-03-05 21:24:11 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |