pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade Failure
7+ messages / 4 participants
[nested] [flat]
* Upgrade Failure
@ 2023-07-18 10:02 Johnathan Tiamoh <johnathantiamoh@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Johnathan Tiamoh @ 2023-07-18 10:02 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade Failure
@ 2023-07-18 10:12 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2023-07-18 10:12 UTC (permalink / raw)
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade Failure
@ 2023-07-18 10:14 Johnathan Tiamoh <johnathantiamoh@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 7+ messages in thread
From: Johnathan Tiamoh @ 2023-07-18 10:14 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-general@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade Failure
@ 2023-07-18 10:14 Daniel Gustafsson <daniel@yesql.se>
parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Daniel Gustafsson @ 2023-07-18 10:14 UTC (permalink / raw)
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; +Cc: pgsql-general@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade Failure
@ 2023-07-18 10:26 Johnathan Tiamoh <johnathantiamoh@gmail.com>
parent: Daniel Gustafsson <daniel@yesql.se>
0 siblings, 2 replies; 7+ messages in thread
From: Johnathan Tiamoh @ 2023-07-18 10:26 UTC (permalink / raw)
To: daniel@yesql.se; +Cc: pgsql-general@lists.postgresql.org
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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade Failure
@ 2023-07-18 10:38 Daniel Gustafsson <daniel@yesql.se>
parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Daniel Gustafsson @ 2023-07-18 10:38 UTC (permalink / raw)
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; +Cc: pgsql-general@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade Failure
@ 2023-07-18 14:44 Ron <ronljohnsonjr@gmail.com>
parent: Johnathan Tiamoh <johnathantiamoh@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Ron @ 2023-07-18 14:44 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-07-18 14:44 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-18 10:02 Upgrade Failure Johnathan Tiamoh <johnathantiamoh@gmail.com>
2023-07-18 10:12 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-07-18 10:14 ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
2023-07-18 10:14 ` Daniel Gustafsson <daniel@yesql.se>
2023-07-18 10:26 ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
2023-07-18 10:38 ` Daniel Gustafsson <daniel@yesql.se>
2023-07-18 14:44 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox