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

Adrian Klaver-4 wrote
> On 5/11/20 2:45 PM, TalGloz wrote:
>> Well I tried your steps, both Postgres 10 and 12 are in perfect running
>> conditions and were shut down using the "systemctl" command. When I
>> execute:
>>
>> /usr/pgsql-12/bin/pg_upgrade --old-bindir=/usr/pgsql-10/bin/
>> --new-bindir=/usr/pgsql-12/bin/ --old-datadir=/var/lib/pgsql/10/data
>> --new-datadir=/var/lib/pgsql/12/data --old-options '-c
>> config_file=/var/lib/pgsql/10/data/postgresql.conf' --new-options '-c
>> config_file=/var/lib/pgsql/12/data/postgresql.conf' --check
>>
>> I get:
>>
>> Performing Consistency Checks
>> -----------------------------
>> Checking cluster versions
>> ok
>> Checking database user is the install user ok
>> Checking database connection settings ok
>> Checking for prepared transactions ok
>> Checking for reg* data types in user tables ok
>> Checking for contrib/isn with bigint-passing mismatch ok
>> Checking for tables WITH OIDS ok
>> Checking for invalid "sql_identifier" user columns ok
>> Checking for presence of required libraries ok
>> Checking database user is the install user ok
>> Checking for prepared transactions ok
>>
>> *Clusters are compatible*
>>
>> But if I execute the same command right after that without the "--check"
>> flag I get:
>>
>> Performing Consistency Checks
>> -----------------------------
>> Checking cluster versions ok
>>
>> The target cluster was not shut down cleanly.
>> Failure, exiting
>>
>>
>> Both of the servers were still shut down. If I start form the beginning
>> with
>> a fresh Prostgres 12 installation and execute the upgrade command right
>> away
>> without the "--check" flag I get the problem described in my original
>> post.
>
> How are you installing Postgres?
>
> Are the 10 and 12 packages coming from the same location?
>
>>
>> Best regards,
>> TalGlo
>>
>>
>>
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>>
>>
>
>
> --
> Adrian Klaver

> adrian.klaver@

This is my output for "ps ax| grep post" it is always the same after
shunting down the services.
11232 pts/0 S+ 0:00 grep --color=auto post

I've used the same installation steps for both of the instances:

1. Add the PostgreSQL Yum Repository (needed to be done once)
2. Install the desired Postgres instance using "sudo dnf install
postgresqlXX-*"

Best regards,
TalGloz

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html