From: Marco DE BOOIJ <marco.maillist@debooy.eu>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Date: Fri, 18 Feb 2022 15:27:34 +0100
Message-ID: <0d7c8622-0ca2-a186-aa72-5829268275d2@debooy.eu> (raw)
In-Reply-To: <CACdHDupmCSG+z2NZt1xar2cpanC4S+-9OiU3hLm4FDa7_Wra6Q@mail.gmail.com>
References: <CACdHDupmCSG+z2NZt1xar2cpanC4S+-9OiU3hLm4FDa7_Wra6Q@mail.gmail.com>
In the past I also used pg_upgrade but then somebody advised me to use
pg_upgradecluster. Since then I use this tool.
pg_dropcluster <new version> main
pg_upgradecluster <previous version> main /bnas/pgdata/postgresql/<new
version>
pg_dropcluster <new version> main
Regards,
Marco
Op 18/02/2022 om 06:17 schreef Yoong S. Chow:
>
> Hi I hope I send this to the right mailing list and able to get some
> help.
>
>
> I was trying to perform `pg_upgrade` from Postgresql-12 to
> Postgresql-13 (after being advised that upgrading from Postgresql-12
> to Postgresql-14 is biting off much more than I could chew... ).
>
> The `pg_upgrade --check` went through OK. But the actual `pg_upgrade`
> always get error at the step of /Creating dump of database
> schemas/ for `postgres` database.
>
> ```
>
> /usr/lib/postgresql/13/bin/pg_upgrade
> --old-datadir=/bnas/pgdata/postgresql/12/main
> --new-datadir=/bnas/pgdata/postgresql/13/main
> --old-bindir=/usr/lib/postgresql/12/bin
> --new-bindir=/usr/lib/postgresql/13/bin --old-options '-c
> config_file=/etc/postgresql/12/main/postgresql.conf' --new-options '-c
> config_file=/etc/postgresql/13/main/postgresql.conf' --check
>
> 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 system-defined composite types in user tables ok
>
> Checking for reg* data types in user tables ok
>
> Checking for contrib/isn with bigint-passing mismatch 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
>
>
> *Clusters are compatible*
>
> postgres@ual:~$ /usr/lib/postgresql/13/bin/pg_upgrade
> --old-datadir=/bnas/pgdata/postgresql/12/main
> --new-datadir=/bnas/pgdata/postgresql/13/main
> --old-bindir=/usr/lib/postgresql/12/bin
> --new-bindir=/usr/lib/postgresql/13/bin --old-options '-c
> config_file=/etc/postgresql/12/main/postgresql.conf' --new-options '-c
> config_file=/etc/postgresql/13/main/postgresql.conf'
>
> 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 system-defined composite types in user tables ok
>
> Checking for reg* data types in user tables ok
>
> Checking for contrib/isn with bigint-passing mismatch ok
>
> Creating dump of global objects ok
>
> Creating dump of database schemas
>
> postgres
>
> *failure*
>
>
> Consult the last few lines of "pg_upgrade_dump_13427.log" for
>
> the probable cause of the failure.
>
> Failure, exiting
>
> ```
>
> Here are the logs: pg_upgrade_server.log
> <https://pastebin.com/ePDpmheE;, pg_upgrade_dump_13427.log
> <https://pastebin.com/YTsU4hYh> and
> tail_postgresql-12-2022-02-16_190344.log <https://pastebin.com/KP8ePVct;.
>
> Additional information:
>
> 1.
>
> An observation on `pg_upgrade --check`. I could not run actual
> `pg_upgrade` directly after the `--check` operation as I will
> always get some `server not shut down properly` error.
>
> 2.
>
> I have PostGIS and a couple other audit/monitoring extensions
> installed on Postgresql-12. I have installed the similar Ubuntu
> PostGIS packages for Postgresql-13. Do I need to run `CREATE
> EXTENSIONS xxx` before performing the `pg_upgrade`?
>
> Have been stuck with this for over a week now, and sincerely hope
> someone could help me. TIA.
>
> chow
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: marco.maillist@debooy.eu, pgsql-admin@lists.postgresql.org
Subject: Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
In-Reply-To: <0d7c8622-0ca2-a186-aa72-5829268275d2@debooy.eu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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