Thanks Fabio for instant reply. I now started 8.4 with 50432 and 9.4 with default port but still its failing ...Can you please suggest what is wrong ?
-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 *failure* Consult the last few lines of "pg_upgrade_server.log" for the probable cause of the failure. There seems to be a postmaster servicing the old cluster. Please shutdown that postmaster and try again. Failure, exiting -bash-4.2$ ps -eaf | grep postgres root 8646 9365 0 08:07 pts/1 00:00:00 su - postgres postgres 8647 8646 0 08:07 pts/1 00:00:00 -bash postgres 9778 1 0 09:17 ? 00:00:00 /usr/bin/postgres -p 50432 -D /var/ericsson/esm-data/postgresql-data/ postgres 9779 9778 0 09:17 ? 00:00:00 postgres: logger process postgres 9781 9778 0 09:17 ? 00:00:00 postgres: writer process postgres 9782 9778 0 09:17 ? 00:00:00 postgres: wal writer process postgres 9783 9778 0 09:17 ? 00:00:00 postgres: autovacuum launcher process postgres 9784 9778 0 09:17 ? 00:00:00 postgres: stats collector process postgres 9900 1 0 09:20 ? 00:00:00 /opt/rh/rh-postgresql94/root/usr/bin/postgres -D /var/ericsson/esm-data/postgresql-data-9.4/ postgres 9901 9900 0 09:20 ? 00:00:00 postgres: logger process postgres 9903 9900 0 09:20 ? 00:00:00 postgres: checkpointer process postgres 9904 9900 0 09:20 ? 00:00:00 postgres: writer process postgres 9905 9900 0 09:20 ? 00:00:00 postgres: wal writer process postgres 9906 9900 0 09:20 ? 00:00:00 postgres: autovacuum launcher process postgres 9907 9900 0 09:20 ? 00:00:00 postgres: stats collector process postgres 9926 8647 0 09:21 pts/1 00:00:00 ps -eaf postgres 9927 8647 0 09:21 pts/1 00:00:00 grep --color=auto postgres -bash-4.2$ netstat -antp | grep 50432 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 127.0.0.1:50432 0.0.0.0:* LISTEN 9778/postgres tcp6 0 0 ::1:50432 :::* LISTEN 9778/postgres -bash-4.2$ netstat -antp | grep 5432 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 9900/postgres tcp6 0 0 ::1:5432 :::* LISTEN 9900/postgres ----------------------------------------------------------------- pg_upgrade run on Wed Apr 18 09:24:47 2018 ----------------------------------------------------------------- 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 >> "pg_upgrade_server.log" 2>&1 pg_ctl: another server might be running; trying to start server anyway 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 Examine the log output. [root@ms-esmon /]# cat ./var/ericsson/esm-data/postgresql-data-9.4/postmaster.pid 9900 /var/ericsson/esm-data/postgresql-data-9.4 1524039630 5432 /var/run/postgresql localhost 5432001 2031616 [root@ms-esmon /]# cat ./var/ericsson/esm-data/postgresql-data/postmaster.pid 9778 /var/ericsson/esm-data/postgresql-data 50432001 1998850 With Best Regards Akshay From: Fabio Pardi <f.pa...@portavita.eu> To: Akshay Ballarpure <akshay.ballarp...@tcs.com>, pgsql-general@lists.postgresql.org Date: 04/18/2018 01:06 PM Subject: Re: pg_upgrade help Hi, please avoid crossposting to multiple mailing lists. You need to run both versions of the database, the old and the new. They need to run on different ports (note that it is impossible to run 2 different processes on the same port, that's not a postgresql thing) On 04/18/2018 09:30 AM, Akshay Ballarpure wrote: > Hi all, > I need help on pg_upgrade from 8.4 to 9.4 version. Appreciate urgent > response. > Installed both version and stopped it. Do i need to run both version or > only one 8.4 or 9.4 . Both should run on 50432 ? > > > -bash-4.2$ id > uid=26(postgres) gid=26(postgres) groups=26(postgres) > context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 > > -bash-4.2$ export OLDCLUSTER=/var/ericsson/esm-data/postgresql-data > -- 8.4 data > -bash-4.2$ export NEWCLUSTER=/var/ericsson/esm-data/postgresql-data-9.4 > -- 9.4 data > > > -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 > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you >