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@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 +