Обсуждение: Upgrade Failure

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

> 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

> 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

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