pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Yoong S. Chow <chowy1026@gmail.com>
To: pgsql-general@lists.postgresql.org
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 16:06:40 +0100
Message-ID: <0e0c7ddf3461dacb46458164b34e56c17baad93a.camel@cybertec.at> (raw)
In-Reply-To: <CACdHDupmCSG+z2NZt1xar2cpanC4S+-9OiU3hLm4FDa7_Wra6Q@mail.gmail.com>
References: <CACdHDupmCSG+z2NZt1xar2cpanC4S+-9OiU3hLm4FDa7_Wra6Q@mail.gmail.com>

On Fri, 2022-02-18 at 13:17 +0800, Yoong S. Chow wrote:
> 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... ).

That was bad advice.

> 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.

Buried in your logs I find

  free(): invalid pointer

Perhaps you have found a PostgreSQL bug.  Then it would be gread if you
could provide a reproducer.

But perhaps there is an extension installed that causes that error?

Does a plain pg_dumpall succeed?

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






view thread (13+ messages)  latest in thread

Message-ID: <0e0c7ddf3461dacb46458164b34e56c17baad93a.camel@cybertec.at>
Permalink:  ../0e0c7ddf3461dacb46458164b34e56c17baad93a.camel@cybertec.at/
Also on:    postgresql.org/message-id/0e0c7ddf3461dacb46458164b34e56c17baad93a.camel@cybertec.at

 · 

reply

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: laurenz.albe@cybertec.at, chowy1026@gmail.com, pgsql-general@lists.postgresql.org, 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: <0e0c7ddf3461dacb46458164b34e56c17baad93a.camel@cybertec.at>

* 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