Re: Move configuration files with pg_upgrade

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.

> 
> Is it possible somehow to migrate these old
> configuration files with pg_upgrade or it shall be done manually?
> 
> Cheers,
> Tanja
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com