Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Yoong S(dot) Chow" <chowy1026(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Date: 2022-02-18 15:06:40
Message-ID: 0e0c7ddf3461dacb46458164b34e56c17baad93a.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2022-02-18 15:07:47 Re: Postgresql 12.9 = Operator issue
Previous Message Satish Nayak [NMC - IT] 2022-02-18 14:59:18 Postgresql 12.9 = Operator issue

Browse pgsql-general by date

  From Date Subject
Next Message Marco DE BOOIJ 2022-02-18 15:31:16 Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Previous Message Laura Smith 2022-02-18 14:54:30 Re: UUID type question