Search Postgresql Archives

Re: pg_upgrade help

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

 



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@xxxxxxxxxxxx>
> To:        Akshay Ballarpure <akshay.ballarpure@xxxxxxx>,
> pgsql-general@xxxxxxxxxxxxxxxxxxxx
> 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
>>
> 




[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