Re: Upgrade Failure

2023-07-18 Thread Ron
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 Da

Re: Upgrade Failure

2023-07-18 Thread Daniel Gustafsson
> On 18 Jul 2023, at 12: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 Right, but what does "pg_controldata" say for the cluster? -- Daniel Gustafsson

Re: Upgrade Failure

2023-07-18 Thread Johnathan Tiamoh
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 wrote: > > On 18 Jul 2023, at 12:02, Johnathan Tiamoh > wrote: > > > The source cluster was not shut down cleanly. > > Failure, exiting

Re: Upgrade Failure

2023-07-18 Thread Daniel Gustafsson
> On 18 Jul 2023, at 12:02, Johnathan Tiamoh 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 y

Re: Upgrade Failure

2023-07-18 Thread Johnathan Tiamoh
Thank You Laurenz. On Tue, Jul 18, 2023 at 6:12 AM Laurenz Albe 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 > >

Re: Upgrade Failure

2023-07-18 Thread Laurenz Albe
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 >   >