Re: Upgrade Failure

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Upgrade Failure
Дата
Msg-id 7bd4204a-ba57-2c12-1dcd-073a1470eb6c@gmail.com
обсуждение исходный текст
Ответ на Re: Upgrade Failure  (Johnathan Tiamoh <johnathantiamoh@gmail.com>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Query take a long time and use no index
Следующее
От: Devin Ivy
Дата:
Сообщение: Effects of dropping a large table