Error with Softlinks after using pg_upgrade
Hello together,
as far as I can see, I found a bug with the tool pg_upgrade under PostgreSQL 9.6.2. After upgrading from Version 9.5.3 to 9.6.2 I still couldn't start the database with the normal command pg_ctl start.
It said Database data are incompatible with the Server. The directory was initialized by PostgreSQL Version 9.6, which is not compatible with Version 9.5.3.
The error in german:
"< 2017-03-02 09:49:20.085 CET > FATAL: Datenbankdateien sind inkompatibel mit Server
< 2017-03-02 09:49:20.085 CET > DETAIL: Das Datenverzeichnis wurde von PostgreSQL Version 9.6 initialisiert, welche nicht mit dieser Version 9.5.3 kompatibel ist."
Only after using the path /usr/pgsql-9.6/bin/pg_ctl start it worked correctly. As far as I could find out, it's a problem with a softlink. The softlink pgsql-pg_ctl shows still to "/usr/pgsql-9.5/bin/pg_ctl". The faulty softlink is located in /etc/alternatives.
Additional Info: I'm using CentOS Linux release 7.2.1511 (Core).
If you need more additional informations, please ask.
Mit freundlichen Grüßen /
Regards
Paul Weiler
EF 9 WL
___________________________________
Tel. +49 30 90222 4342
Paul.Weiler@itdz-berlin.de<mailto:Paul.Weiler@itdz-berlin.de>
IT-Dienstleistungszentrum Berlin
Anstalt des öffentlichen Rechts
Berliner Straße 112-115
10713 Berlin
Handelsregisternr.: HRA 36349 B
Registergericht: Amtsgericht Charlottenburg
www.itdz-berlin.de<http://www.itdz-berlin.de/>
www.itdz.verwalt-berlin.de<http://www.itdz.verwalt-berlin.de/>
Das ITDZ Berlin ist mit dem BSI-Zertifikat nach ISO 27001 auf Basis IT-Grundschutz ausgezeichnet.
Das ITDZ Berlin ist im Rahmen des "audit berufundfamilie" als familienbewusstes Unternehmen zertifiziert.
<Paul.Weiler@itdz-berlin.de> writes:
as far as I can see, I found a bug with the tool pg_upgrade under PostgreSQL 9.6.2. After upgrading from Version 9.5.3 to 9.6.2 I still couldn't start the database with the normal command pg_ctl start.
...
Only after using the path /usr/pgsql-9.6/bin/pg_ctl start it worked correctly. As far as I could find out, it's a problem with a softlink. The softlink pgsql-pg_ctl shows still to "/usr/pgsql-9.5/bin/pg_ctl". The faulty softlink is located in /etc/alternatives.
pg_upgrade, per se, doesn't and cannot know about such things ---
/etc/alternatives is a platform-specific concept and any symlinks placed
there must have been created by a platform-specific packaging of Postgres.
I expect that the packager provided some upgrade instructions that would
involve running pg_upgrade as one step. Try looking into whatever README
or similar files were included in your Postgres RPMs.
If you were following a package-specific upgrade recipe, then this is a
bug in the recipe --- but you'd need to report it to the packager, not
to the PG project.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs