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