Re: Upgrade Process Says "The database server was not shut down cleanly" but it was

On 5/3/20 3:33 PM, TalGloz wrote:
> Adrian Klaver-4 wrote
>> On 5/3/20 3:11 PM, TalGloz wrote:
>>> Adrian Klaver-4 wrote
>>>> On 5/3/20 2:53 PM,
>>>>
>>>> Looks like you did not shutdown the 12 instance.
>>>>
>>>> --
>>>> Adrian Klaver
>>>
>>>> adrian.klaver@
>>>
>>>
>>> This is weird because "systemctl staus postgresql-12.service" shows that
>>> the
>>> service is dead.
>>
>> It is now:
>> "The database server was not shut down cleanly."
>>
>> Before running pg_upgrade again I would:\
>>
>> 1) Start the 12 instance to make sure it will start cleanly.
>>
>> 2) Shut it and the 10 instance down.
>>
>> 3) Try the pg_upgrade again this time with:
>>
>> https://www.postgresql.org/docs/12/pgupgrade.html
>>
>> --check
>>
>> check clusters only, don't change any data
>>
>> 4) Assuming 3) completes, repeat w/o --check
>>
>>>
>>> Best regards,
>>> TalGloz
>>>
>>>
>>>
>>> --
>>> Sent from:
>>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>>>
>>>
>>
>>
>> --
>> Adrian Klaver
>
>> adrian.klaver@
>
>
> Thanks I'll try your steps tommorow. What I meant to say is that "systemctl
> staus postgresql-12.service" was always showing that the service is dead,
> even before I've started the upgrade process.

Hmm, then maybe the unclean shutdown was from a previous use. At at any
rate you passed this point in the process:

"If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing."

You are going to need to start with a fresh cluster anyway.

>
> Best regards,
> TalGloz
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com