Re: 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>*
> *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