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-10 04:10:40 |
Message-ID: | 20180910041040.GB13949@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, Sep 10, 2018 at 09:30:28AM +0530, kalyani kaniganti wrote:
> Hi Bruce,
> Thanks for the immediate reply.
> We are using pg_ctl command to shutdown the old server with no option.In this
> case the pg_ctl will consider as smart shutdown if no option is specified as
> per documentation .
> please find bellow command.
> <new path for data dir>/bin/pg_ctl -D <olddata dir path> stop
Yes, this should be fine.
> We are using the same script for multiple releases in Postgres sql to upgrade
> the database from 9.1 to 9.4 .
> Same script is working fine in 9.4.17 version, while upgrading DB from 9.1 to
> 9.4.17.
OK.
> From the release notes of 9.4.19 version we did not find any changes done on
> pg_upgrade except one bug fix related to pg_upgrade has been fixed.
> Do we have to add in our code to check for graceful shutdown or we have to wait
> for the next release?
> Please let us know if you have any workaround till the next minor patch is
> released.
Well, there is nothing pending in the next beta except a better error
message text. Can you show me the commands and the error you are
getting. The system is looking at the output from:
$ pg_controldata $PGDATA
The "Database cluster state:" must be "shut down" before running
pg_upgrade.
--
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 | Rafia Sabih | 2018-09-10 09:26:19 | Re: log_destination reload/restart doesn't stop file creation |
Previous Message | kalyani kaniganti | 2018-09-10 04:00:28 | Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error The source cluster was not shut down cleanly. |