Re: pg_upgrade help - Mailing list pgsql-general

From Akshay Ballarpure
Subject Re: pg_upgrade help
Date
Msg-id OF2512B412.F77CCFE3-ON65258274.0027EFA1-65258274.0029BCC5@tcs.com
Whole thread Raw
In response to Re: pg_upgrade help  (Fabio Pardi <f.pardi@portavita.eu>)
Responses Re: pg_upgrade help
List pgsql-general
Hi Fabio,
Yes i ran initdb on new database and able to start as below.

[root@ms-esmon root]# su - postgres -c "/usr/bin/postgres -p 50432 -D /var/ericsson/esm-data/postgresql-data/ 2>&1 &"
[root@ms-esmon root]# su - postgres -c "/opt/rh/rh-postgresql94/root/usr/bin/postgres -D /var/ericsson/esm-data/postgresql-data-9.4/ 2>&1 &"
[root@ms-esmon root]# 2018-04-19 08:17:53.553 IST  LOG:  redirecting log output to logging collector process
2018-04-19 08:17:53.553 IST  HINT:  Future log output will appear in directory "pg_log".

[root@ms-esmon root]#
[root@ms-esmon root]# ps -eaf | grep postgre
sroot      8646  9365  0 Apr18 pts/1    00:00:00 su - postgres
postgres  8647  8646  0 Apr18 pts/1    00:00:00 -bash
postgres 28009     1  2 08:17 ?        00:00:00 /usr/bin/postgres -p 50432 -D /var/ericsson/esm-data/postgresql-data/  --8.4
postgres 28010 28009  0 08:17 ?        00:00:00 postgres: logger process
postgres 28012 28009  0 08:17 ?        00:00:00 postgres: writer process
postgres 28013 28009  0 08:17 ?        00:00:00 postgres: wal writer process
postgres 28014 28009  0 08:17 ?        00:00:00 postgres: autovacuum launcher process
postgres 28015 28009  0 08:17 ?        00:00:00 postgres: stats collector process
postgres 28048     1  0 08:17 ?        00:00:00 /opt/rh/rh-postgresql94/root/usr/bin/postgres -D /var/ericsson/esm-data/postgresql-data-9.4/
postgres 28049 28048  0 08:17 ?        00:00:00 postgres: logger process
postgres 28051 28048  0 08:17 ?        00:00:00 postgres: checkpointer process
postgres 28052 28048  0 08:17 ?        00:00:00 postgres: writer process
postgres 28053 28048  0 08:17 ?        00:00:00 postgres: wal writer process
postgres 28054 28048  0 08:17 ?        00:00:00 postgres: autovacuum launcher process
postgres 28055 28048  0 08:17 ?        00:00:00 postgres: stats collector process
root     28057  2884  0 08:17 pts/0    00:00:00 grep --color=auto postgre


Also i am able to start db with the command provided by you and run psql.

/opt/rh/rh-postgresql94/root/usr/bin/pg_ctl  start -o "-p 50432 -c listen_addresses='' -c unix_socket_permissions=0700"  -D /var/ericsson/esm-data/postgresql-data-9.4/
pg_ctl: another server might be running; trying to start server anyway
server starting
-bash-4.2$ 2018-04-19 08:22:46.527 IST  LOG:  redirecting log output to logging collector process
2018-04-19 08:22:46.527 IST  HINT:  Future log output will appear in directory "pg_log".

-bash-4.2$ ps -eaf | grep postg
root      8646  9365  0 Apr18 pts/1    00:00:00 su - postgres
postgres  8647  8646  0 Apr18 pts/1    00:00:00 -bash
postgres 28174     1  0 08:22 pts/1    00:00:00 /opt/rh/rh-postgresql94/root/usr/bin/postgres -D /var/ericsson/esm-data/postgresql-data-9.4 -p 50432 -c listen_addresses= -c unix_socket_permissions=0700
postgres 28175 28174  0 08:22 ?        00:00:00 postgres: logger process
postgres 28177 28174  0 08:22 ?        00:00:00 postgres: checkpointer process
postgres 28178 28174  0 08:22 ?        00:00:00 postgres: writer process
postgres 28179 28174  0 08:22 ?        00:00:00 postgres: wal writer process
postgres 28180 28174  0 08:22 ?        00:00:00 postgres: autovacuum launcher process
postgres 28181 28174  0 08:22 ?        00:00:00 postgres: stats collector process
postgres 28182  8647  0 08:22 pts/1    00:00:00 ps -eaf
postgres 28183  8647  0 08:22 pts/1    00:00:00 grep --color=auto postg

-bash-4.2$ psql -p 50432 -h /var/run/postgresql -U rhqadmin -d rhq
psql (8.4.20, server 9.4.9)
WARNING: psql version 8.4, server version 9.4.
         Some psql features might not work.
Type "help" for help.

rhq=>


Still its failing...

-bash-4.2$ ps -efa | grep postgre
root      8646  9365  0 Apr18 pts/1    00:00:00 su - postgres
postgres  8647  8646  0 Apr18 pts/1    00:00:00 -bash
postgres 28349  8647  0 08:34 pts/1    00:00:00 ps -efa
postgres 28350  8647  0 08:34 pts/1    00:00:00 grep --color=auto postgre

-bash-4.2$ echo $OLDCLUSTER
/usr/bin/postgres
-bash-4.2$ echo $NEWCLUSTER
/opt/rh/rh-postgresql94/

[root@ms-esmon rh-postgresql94]# /opt/rh/rh-postgresql94/root/usr/bin/pg_upgrade --old-bindir=/usr/bin --new-bindir=/opt/rh/rh-postgresql94/root/usr/bin --old-datadir=/var/ericsson/esm-data/postgresql-data --new-datadir=/var/ericsson/esm-data/postgresql-data-9.4

Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok

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
Ericsson OSS MON
Tata Consultancy Services
Mailto: akshay.ballarpure@tcs.com
Website:
http://www.tcs.com
____________________________________________
Experience certainty.        IT Services
                       Business Solutions
                       Consulting
____________________________________________




From:        Fabio Pardi <f.pardi@portavita.eu>
To:        Akshay Ballarpure <akshay.ballarpure@tcs.com>
Cc:        pgsql-general@lists.postgresql.org
Date:        04/18/2018 06:17 PM
Subject:        Re: pg_upgrade help




did you run initdb on the new db?

what happens if you manually start the new db?

/opt/rh/rh-postgresql94/root/usr/bin/pg_ctl  start -o "-p 50432 -c
listen_addresses='' -c unix_socket_permissions=0700"  -D $NEWCLUSTER

after starting it, can you connect to it using psql?

psql -p 50432 -h /var/run/postgresql  -U your_user _db_



regards,

fabio pardi


On 04/18/2018 02:02 PM, Akshay Ballarpure wrote:
> Hi Fabio,
> sorry to bother you again, its still failing with stopping both server
> (8.4 and 9.4)
>
> -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
> Ericsson OSS MON
> Tata Consultancy Services
> Mailto: akshay.ballarpure@tcs.com
> Website:
http://www.tcs.com <http://www.tcs.com/>
> ____________________________________________
> Experience certainty.        IT Services
>                        Business Solutions
>                        Consulting
> ____________________________________________
>
>
>
>
> From:        Fabio Pardi <f.pardi@portavita.eu>
> To:        Akshay Ballarpure <akshay.ballarpure@tcs.com>,
> pgsql-general@lists.postgresql.org
> Date:        04/18/2018 02:35 PM
> Subject:        Re: pg_upgrade help
> ------------------------------------------------------------------------
>
>
>
> Hi,
>
> i was too fast in reply (and perhaps i should drink my morning coffee
> before replying), I will try to be more detailed:
>
> both servers should be able to run at the moment you run pg_upgrade,
> that means the 2 servers should have been correctly stopped in advance,
> should have their configuration files, and new cluster initialized too.
>
> Then, as Sergei highlights here below, pg_upgrade will take care of the
> upgrade process, starting the servers.
>
>
> Here there is a step by step guide, i considered my best ally when it
> was time to upgrade:
>
>
https://www.postgresql.org/docs/9.4/static/pgupgrade.html
>
> note point 7:
>
> 'stop both servers'
>
>
> About the port the servers will run on, at point 9 there is some
> clarification:
>
> ' pg_upgrade defaults to running servers on port 50432 to avoid
> unintended client connections. You can use the same port number for both
> clusters when doing an upgrade because the old and new clusters will not
> be running at the same time. However, when checking an old running
> server, the old and new port numbers must be different.'
>
> Hope it helps,
>
> Fabio Pardi
>
>
> On 04/18/2018 10:34 AM, Akshay Ballarpure wrote:
>> 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.pardi@portavita.eu>
>> To:        Akshay Ballarpure <akshay.ballarpure@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
>>>
>>
>

pgsql-general by date:

Previous
From: Enrico Pirozzi
Date:
Subject: Re: New website
Next
From: Pavel Raiskup
Date:
Subject: obsoleting plpython2u and defaulting plpythonu to plpython3u