Thread: [BUGS] Error with Softlinks after using pg_upgrade

[BUGS] Error with Softlinks after using pg_upgrade

From
Date:

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

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
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.

 

Re: [BUGS] Error with Softlinks after using pg_upgrade

From
Tom Lane
Date:
<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.3to 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
problemwith a softlink. The softlink pgsql-pg_ctl shows still to "/usr/pgsql-9.5/bin/pg_ctl". The faulty softlink is
locatedin /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