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.klaver@aklaver.com