Search Postgresql Archives

Re: pg_upgrade help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux