Обсуждение: Upgrade to postgres 10 - Postmaster not getting shutdown

Поиск
Список
Период
Сортировка

Upgrade to postgres 10 - Postmaster not getting shutdown

От
Debraj Manna
Дата:
Hi 

I am trying to upgrade to postgres 10 from 9.5.4. On doing the compatibility check I am getting the below error. 

ubuntu@vrni-platform-release:/tmp$ sudo service postgresql stop
 * Stopping PostgreSQL 10 database server                                                                                                                                                            [ OK ]
 * Stopping PostgreSQL 9.5 database server                                                                                                                                                           [ OK ]


ubuntu@vrni-platform-release:/tmp$ sudo -H -u postgres /usr/lib/postgresql/10/bin/pg_upgrade -b /usr/lib/postgresql/9.5/bin -B /usr/lib/postgresql/10/bin -d /var/lib/postgresql/data/postgresql0 -D /var/lib/postgresql/10/data/postgresql0 -o ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf' -O ' -c config_file=/etc/postgresql/10/main/postgresql.conf' --check -k

There seems to be a postmaster servicing the new cluster.
Please shutdown that postmaster and try again.
Failure, exiting

Can some one let me know what is going wrong here and how can I get around this?

Thanks,
Debraj

Re: Upgrade to postgres 10 - Postmaster not getting shutdown

От
MichaelDBA
Дата:
Make sure no other pg services are still running:

ps -ef | grep postgres

Otherwise, check and remove the postgresql pid file if it still exists.

Regards,
Michael Vitale


Debraj Manna wrote:
There seems to be a postmaster servicing the new cluster.

RE: Upgrade to postgres 10 - Postmaster not getting shutdown

От
David Modica
Дата:

check your environmental variables for the correct path

 

From: Debraj Manna <subharaj.manna@gmail.com>
Sent: Friday, July 13, 2018 8:12 AM
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Upgrade to postgres 10 - Postmaster not getting shutdown

 

Hi 

 

I am trying to upgrade to postgres 10 from 9.5.4. On doing the compatibility check I am getting the below error. 

 

ubuntu@vrni-platform-release:/tmp$ sudo service postgresql stop

 * Stopping PostgreSQL 10 database server                                                                                                                                                            [ OK ]

 * Stopping PostgreSQL 9.5 database server                                                                                                                                                           [ OK ]

 

 

ubuntu@vrni-platform-release:/tmp$ sudo -H -u postgres /usr/lib/postgresql/10/bin/pg_upgrade -b /usr/lib/postgresql/9.5/bin -B /usr/lib/postgresql/10/bin -d /var/lib/postgresql/data/postgresql0 -D /var/lib/postgresql/10/data/postgresql0 -o ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf' -O ' -c config_file=/etc/postgresql/10/main/postgresql.conf' --check -k

 

There seems to be a postmaster servicing the new cluster.

Please shutdown that postmaster and try again.

Failure, exiting

 

Can some one let me know what is going wrong here and how can I get around this?

 

Thanks,

Debraj