Re: PostgreSQL Upgrade 11 to 12

On Fri, 2021-01-08 at 08:20 +0000, pgdba pgdba wrote:
> Hi everyone,
> I want to upgrade the postgresql cluster. The structure I use is streaming replication method on 2 nodes(one master, one slave). The version I want to upgrade is 11 to 12.
> but I am getting the following error during the upgrade. Can you support me? Thanks.
>
> -bash-4.2$ /usr/pgsql-12/bin/pg_upgrade --old-datadir=/var/lib/pgsql/11/data --new-datadir=/var/lib/pgsql/12/data --old-bindir=/usr/pgsql-11/bin --new-bindir=/usr/pgsql-12/bin --check
> Performing Consistency Checks on Old Live Server
> ------------------------------------------------
> 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
> Checking for new cluster tablespace directories ok
> Error;
> -bash-4.2$ /usr/pgsql-12/bin/pg_upgrade --old-datadir=/var/lib/pgsql/11/data --new-datadir=/var/lib/pgsql/12/data --old-bindir=/usr/pgsql-11/bin --new-bindir=/usr/pgsql-12/bin
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions ok
>
> The source cluster was shut down while in recovery mode. To upgrade, use "rsync" as documented or shut it down as a primary.
> Failure, exiting

You cannot "pg_upgrade" the standby server.

Look at step 10 in the documentation at https://www.postgresql.org/docs/current/pgupgrade.html

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com