RE: Upgrade to postgres 10 - Postmaster not getting shutdown

From: David Modica <davidmo(at)imaginesoftware(dot)com>
To: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: RE: Upgrade to postgres 10 - Postmaster not getting shutdown
Date: 2018-07-13 12:22:38
Message-ID: 2da56cce8dfa4d5d849557450ce2f7f7@imaginesoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

check your environmental variables for the correct path

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
Sent: Friday, July 13, 2018 8:12 AM
To: pgsql-admin <pgsql-admin(at)postgresql(dot)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(at)vrni-platform-release:/tmp$ sudo service postgresql stop
* Stopping PostgreSQL 10 database server [ OK ]
* Stopping PostgreSQL 9.5 database server [ OK ]

ubuntu(at)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2018-07-13 18:18:15 Default locale in postgres
Previous Message MichaelDBA 2018-07-13 12:22:09 Re: Upgrade to postgres 10 - Postmaster not getting shutdown