From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | kalyani kaniganti <kalyanithumati(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error The source cluster was not shut down cleanly. |
Date: | 2018-09-11 02:34:39 |
Message-ID: | 20180911023439.GA27769@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Sep 11, 2018 at 07:20:47AM +0530, kalyani kaniganti wrote:
> Hi Bruce.
>
> Below commands are executed.
>
> pg_ctl -D <path to old data> stop
>
> output
> pg_ctl: PID file "/tmp/folder/postgresql/postmaster.pid" does not exist
> Is server running?
>
> pg_controldata <path to old data> output displayed as Database cluster : in
> production
>
> pg_ctl status displays server not running
>
> We have performed same steps and executed this script with 9.4.17 version of
> postgreSQL and its working fine.
> We can get the upgarded DB and we have compared the pg_control data in 9.4.17
> version we can see the DB cluster status is in shut down state for NEW DB data
> and OLD DB data.
>
> We are not understanding what has changed from 9.4.17 to 9.4.19.
My guess is that Postgres was improperly shut down before you tried
using pg_ctl stop. Of course, you didn't show me anything exact, so I
can only guess.
--
Bruce Momjian <bruce(at)momjian(dot)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 +
From | Date | Subject | |
---|---|---|---|
Next Message | Haotian Yang | 2018-09-11 03:06:06 | `pg_trgm` not recognizing Chinese characters in macOS |
Previous Message | Tom Lane | 2018-09-11 02:24:14 | Re: BUG #15367: Crash in pg_fe_scram_free when using foreign tables |