Move configuration files with pg_upgrade

On 2020-06-04 19:52:19 +0000, Tanja Savic wrote:

I did Postgresql upgrade from v10 to v12 using pg_upgrade (on Linux Ubuntu
server).

Did you use the packages from the PGDG server or from Ubuntu?

Of course i wanted settings in pg_hba.conf and postgresql.conf to keep, but
after the upgrade there were new configuration files and I moved it manually.

I recently did an upgrade from 9.6 to 12 on a Debian system (using the
PGDG packages - I think they should be the same for Debian and Ubuntu)
and pg_uprade migrated the existing configuration without problems.
So that's not a general problem - did you get any error messages or
warnings during the upgrade?

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

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

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