Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error Thesource cluster was not shut down cleanly. - Mailing list pgsql-bugs

From kalyani kaniganti
Subject Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error Thesource cluster was not shut down cleanly.
Date
Msg-id CACAAi_5FnpZOjgbkUG9cM6RaKDUFNEZHi7Dt2qjQ5ueNTJtaow@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error Thesource cluster was not shut down cleanly.  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error Thesource cluster was not shut down cleanly.
List pgsql-bugs
Hi Bruce,
We have performed the same steps.
But pg_ctl is throwing error as postmaster.pid is not found in old path and displays as is sever running ?
pg_ctl status display output as server not running.
May I know it's an bug in 9.4.19 .Any other suggestions ?
BR,
Kalyani


On Mon, Sep 10, 2018, 10:17 PM Bruce Momjian <bruce@momjian.us> wrote:
On Mon, Sep 10, 2018 at 12:14:43PM -0400, Bruce Momjian wrote:
> On Mon, Sep 10, 2018 at 05:34:14PM +0530, kalyani kaniganti wrote:
> > Hi Bruce,
> >
> > We have checked cluster status on both the server's data and we noticed source
> > cluster state is in production and destination cluster state in shutdown.
> > Database cluster state:               in production
> > Database cluster state:               shut down
> >
> > How can we shut down the Database cluster?
>
> Uh, pg_ctl and point to the running data directory.

Let me be more specific:

        $ pg_ctl -D path-to-old-cluster stop

e.g.,

        $ pg_ctl -D /u/pg-old/data stop
        waiting for server to shut down.... done
        server stopped

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error Thesource cluster was not shut down cleanly.
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #15367: Crash in pg_fe_scram_free when using foreign tables