Postgres Pro
Downloads
Home   >   mailing lists

Thread: Upgrade Failure

Upgrade Failure

From
Johnathan Tiamoh
Date:
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

Re: Upgrade Failure

From
Laurenz Albe
Date:
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, exiting
>
> Please how do you resolve this

Well, start the 9.5 server and shut it down cleanly.

Yours,
Laurenz Albe

Re: Upgrade Failure

From
Johnathan Tiamoh
Date:
Thank You  Laurenz.

On Tue, Jul 18, 2023 at 6:12 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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, exiting
>
> Please how do you resolve this

Well, start the 9.5 server and shut it down cleanly.

Yours,
Laurenz Albe

Re: Upgrade Failure

From
Daniel Gustafsson
Date:
> On 18 Jul 2023, at 12:02, Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:

> The source cluster was not shut down cleanly.
> Failure, exiting
>
> Please 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

Re: Upgrade Failure

From
Johnathan Tiamoh
Date:
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, exiting
>
> Please 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

Re: Upgrade Failure

From
Daniel Gustafsson
Date:
> 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

Re: Upgrade Failure

From
Ron
Date:
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, exiting
>
> Please 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.