pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade to postgres 10 - Postmaster not getting shutdown
3+ messages / 3 participants
[nested] [flat]
* Upgrade to postgres 10 - Postmaster not getting shutdown
@ 2018-07-13 12:12 Debraj Manna <subharaj.manna@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Debraj Manna @ 2018-07-13 12:12 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrade to postgres 10 - Postmaster not getting shutdown
@ 2018-07-13 12:22 MichaelDBA <MichaelDBA@sqlexec.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: MichaelDBA @ 2018-07-13 12:22 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Upgrade to postgres 10 - Postmaster not getting shutdown
@ 2018-07-13 12:22 David Modica <davidmo@imaginesoftware.com>
parent: Debraj Manna <subharaj.manna@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: David Modica @ 2018-07-13 12:22 UTC (permalink / raw)
To: Debraj Manna <subharaj.manna@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-07-13 12:22 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-13 12:12 Upgrade to postgres 10 - Postmaster not getting shutdown Debraj Manna <subharaj.manna@gmail.com>
2018-07-13 12:22 ` MichaelDBA <MichaelDBA@sqlexec.com>
2018-07-13 12:22 ` David Modica <davidmo@imaginesoftware.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox