upgrade issue 10 to 11

On 4/17/19 4:08 AM, Prakash Ramakrishnan wrote:

Hi Team,

While using pg_upgrade 10 to 11 version we are getting below
error.Please do the needful.

postgres@hamrhenppp001.enterprisenet.org:/BACKUP/hamrhenppp001/upgrade_logs
==> /usr/pgsql-11/bin/pg_upgrade -d /DATA/data10 -D /DATA/data11 -b
/opt/app/PostgreSQL/10/bin -B /usr/pgsql-11/bin -p 5432 -P 5434 -c
*
*
*libpq environment variable PGHOST has a non-local server value:
HAMRHENPPP001.enterprisenet.org <http://HAMRHENPPP001.enterprisenet.org&gt;*
*Failure, exiting*

Pretty straight forward. The environment
variable(www.postgresql.org/docs/10/libpq-envars.html) PGHOST has been
set and it points to host that is not local. Unset the PGHOST or set it
to a localhost.

--

Regards,
Prakash.R
Postgresql DBA

--
Adrian Klaver
adrian.klaver@aklaver.com