Comment 5 for bug 1437862

Revision history for this message
Andrew B (n-launchpad-lineum-org) wrote :

Hi,

In my instance this error originated deep down in the call stack in get_cluster_port in /usr/share/Perl5/Pgcommon.pm when attempting to upgrade from 9.3 to 9.5

In my postgresql.conf for the old 9.3 cluster I had the port line commented-out per the default configuration file:

#port = 5432

This worked fine in production since Postgres defaults to that port number when not defined. However its absence was causing get_cluster_port to fail and this was propagating up the call stack to get_encoding in pg_upgradecluster.

I decommented the port line:

port = 5432

and reran pg_upgradecluster with success.