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(at)hamrhenppp001(dot)enterprisenet(dot)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(dot)klaver(at)aklaver(dot)com