Re: pg_upgrade help

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(at)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(at)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(dot)pardi(at)portavita(dot)eu>
To: Akshay Ballarpure <akshay(dot)ballarpure(at)tcs(dot)com>,
pgsql-general(at)lists(dot)postgresql(dot)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
>