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@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

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