| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Edwin UY <edwin(dot)uy(at)gmail(dot)com> |
| Cc: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, 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:11 |
| Message-ID: | 5E4F62CA-BFEA-4F54-B1CB-F47D23CA32E1@elevated-dev.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Mar 5, 2025, at 2:18 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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-03-05 21:24:24 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |
| Previous Message | Edwin UY | 2025-03-05 21:18:59 | Re: Comparing Parameters PRE- and POST- Upgrade - Any script? |