Re: pg_upgrade help

On 04/18/2018 05:02 AM, Akshay Ballarpure wrote:
> Hi Fabio,
> sorry to bother you again, its still failing with stopping both server
> (8.4 and 9.4)

Actually according to the command show at bottom of post it is failing
trying to start the 8.4 server. In your previous post that was because
it was already running:

-bash-4.2$ ps -eaf | grep postgres
postgres 9778 1 0 09:17 ? 00:00:00 /usr/bin/postgres -p
50432 -D /var/ericsson/esm-data/postgresql-data/

FATAL: lock file "postmaster.pid" already exists
HINT: Is another postmaster (PID 9778) running in data directory
"/var/ericsson/esm-data/postgresql-data"?
pg_ctl: could not start server

Make sure both servers are stopped before running pg_upgrade. Per a
previous suggestion follow the check list here:

https://www.postgresql.org/docs/10/static/pgupgrade.html
"
Usage

These are the steps to perform an upgrade with pg_upgrade:

...

"

>
> -bash-4.2$ /opt/rh/rh-postgresql94/root/usr/bin/pg_upgrade
> --old-bindir=/usr/bin --new-bindir=/opt/rh/rh-postgresql94/root/usr/bin
> --old-datadir=$OLDCLUSTER --new-datadir=$NEWCLUSTER
>
> connection to database failed: could not connect to server: No such file
> or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.50432"?
>
>
> could not connect to old postmaster started with the command:
> "/usr/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
> "/var/ericsson/esm-data/postgresql-data" -o "-p 50432 -c autovacuum=off
> -c autovacuum_freeze_max_age=2000000000  -c listen_addresses='' -c
> unix_socket_permissions=0700" start
> Failure, exiting
>
>
> With Best Regards
> Akshay

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com