Upgrade Failure
Hello,
I was running an upgrade from 9.5 to 14.8 and encountered the below error.
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
The source cluster was not shut down cleanly.
Failure, exiting
Please how do you resolve this
Kind Regards
Tiamoh M
On Tue, 2023-07-18 at 06:02 -0400, Johnathan Tiamoh wrote:
I was running an upgrade from 9.5 to 14.8 and encountered the below error.
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
The source cluster was not shut down cleanly.
Failure, exitingPlease how do you resolve this
Well, start the 9.5 server and shut it down cleanly.
Yours,
Laurenz Albe
Thank You Laurenz.
On Tue, Jul 18, 2023 at 6:12 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
Show quoted text
On Tue, 2023-07-18 at 06:02 -0400, Johnathan Tiamoh wrote:
I was running an upgrade from 9.5 to 14.8 and encountered the below
error.
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions okThe source cluster was not shut down cleanly.
Failure, exitingPlease how do you resolve this
Well, start the 9.5 server and shut it down cleanly.
Yours,
Laurenz Albe
On 18 Jul 2023, at 12:02, Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
The source cluster was not shut down cleanly.
Failure, exitingPlease how do you resolve this
pg_upgrade runs bin/pg_controldata on the source cluster data directory and
ensures that the "Database cluster state" says "shut down". If you run the
same command, which state is the cluster reported to be in?
--
Daniel Gustafsson
I used pg_ctl to stop the cluster.
When I used the same pg_ctl to check status, it says no server is running
On Tue, Jul 18, 2023 at 6:14 AM Daniel Gustafsson <daniel@yesql.se> wrote:
Show quoted text
On 18 Jul 2023, at 12:02, Johnathan Tiamoh <johnathantiamoh@gmail.com>
wrote:
The source cluster was not shut down cleanly.
Failure, exitingPlease how do you resolve this
pg_upgrade runs bin/pg_controldata on the source cluster data directory and
ensures that the "Database cluster state" says "shut down". If you run the
same command, which state is the cluster reported to be in?--
Daniel Gustafsson
On 18 Jul 2023, at 12:26, Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
I used pg_ctl to stop the cluster.
When I used the same pg_ctl to check status, it says no server is running
Right, but what does "pg_controldata" say for the cluster?
--
Daniel Gustafsson
pg_ctl is not pg_controldata.
(I bet you ran "pg_ctl stop --mode=immediate". That's not a clean shutdown.)
On 7/18/23 05:26, Johnathan Tiamoh wrote:
I used pg_ctl to stop the cluster.
When I used the same pg_ctl to check status, it says no server is running
On Tue, Jul 18, 2023 at 6:14 AM Daniel Gustafsson <daniel@yesql.se> wrote:
On 18 Jul 2023, at 12:02, Johnathan Tiamoh
<johnathantiamoh@gmail.com> wrote:
The source cluster was not shut down cleanly.
Failure, exitingPlease how do you resolve this
pg_upgrade runs bin/pg_controldata on the source cluster data
directory and
ensures that the "Database cluster state" says "shut down". If you run the
same command, which state is the cluster reported to be in?--
Daniel Gustafsson
--
Born in Arizona, moved to Babylonia.