| From: | Edwin UY <edwin(dot)uy(at)gmail(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | 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:18:59 |
| Message-ID: | CA+wokJ_eK9RTaRYXfVaCSfzfbc1Xn2TxTXfjOOBdWv9DP=yG0Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2025-03-05 21:24:11 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |
| Previous Message | Ron Johnson | 2025-03-05 21:03:14 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |