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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/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@xxxxxxxxxxx
