## marco.ptz@tiscali.it (marco.ptz@tiscali.it):
> we have recently started to manage a production server
> running a 9.6 postgres.
Which is EOL for nearly two years now:
https://www.postgresql.org/support/versioning/
> We
> have to upgrade to postgres 12.x
Which is going EOL in little over one year's time.
You should look into https://yum.postgresql.org/packages/ where you
can get packages with some real production life time.
> At present in /usr/bin there are not links as
> aspected for use with alternatives, but there are files belonging to
> 9.2
> version except for pg_basebackup:
That sounds severly broken, as if you installed CentOS original
"postgresql" package (CentOS 7 ships with the really ancient 9.2).
Check rpm and yum where that came from and then it's time for some
cleanup. In the mean time, make sure to always call all PostgreSQL
utilities with full path.
> Could
> we have trouble having 9.6 and 12 running in the same time (we will
> upgrade with pg_upgrade) in such server?
For pg_upgrade, you will need both the old and new binaries installed.
> HOW can we to fix the presence
> of release 9.2 files in /usr/bin?
Maybe best use the upgrade opportunity to move everything to a clean
installation on a new VM?
> Will the simbolic links in /usr/bin be
> created by alternatives once the 9.2 release will be
> dropped/deinstalled/deleted?
The symlinks would be created by registering the repective versions
with the alternatives system - usually that happens in the post-install
scripts of the RPMs. You could do that manually (after removing 9.2)
or maybe by re-installing your current (ancient) packages. Cleanest
solution would be a new server - who knows what other surprises are
hidden on that machine?
Regards,
Christoph
--
Spare Space.