Re: Move configuration files with pg_upgrade

On Thu, Jun 4, 2020 at 03:26:07PM -0700, Adrian Klaver wrote:
> On 6/4/20 12:52 PM, Tanja Savic wrote:
> > Hello,
> >
> > I did Postgresql upgrade from v10 to v12 using pg_upgrade (on Linux
> > Ubuntu server).
> > Of course i wanted settings inpg_hba.conf and postgresql.conf to keep,
> > but after the upgrade there were new configuration files and I moved it
> > manually.
>
> That is documented:
>
> https://www.postgresql.org/docs/12/pgupgrade.html
>
> "
> Restore pg_hba.conf
>
> If you modified pg_hba.conf, restore its original settings. It might also be
> necessary to adjust other configuration files in the new cluster to match
> the old cluster, e.g. postgresql.conf.
> "
>
> The new version's conf files will probably have new settings available so
> this is something that should be reviewed before moving over. One way to
> deal with this is include file(s):
>
> https://www.postgresql.org/docs/12/config-setting.html#CONFIG-INCLUDES
>
> Using them you create the settings you want to manage in the include file.
> Then copy that over and set the include 'some_file' in the new
> postgresql.conf and you are good.

Yes, the community instructions require you to reconfigure the new
server to match the old one. Some packagers who automate pg_upgrade
might do that configuration migration automatically.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee