Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters - Mailing list pgsql-general

From Ken Yeung
Subject Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters
Date
Msg-id VI1PR01MB49268B47C0985A4D249485A0C0899@VI1PR01MB4926.eurprd01.prod.exchangelabs.com
Whole thread Raw
In response to Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view 
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Wednesday, July 13, 2022 3:16 AM

> You configured "pg_hba.conf" so that a local login without password is
> not possible.  The easiest solution is to change the "pg_hba.conf"
> entries for "localhost" in IPv4 and IPv6 to "trust" for the duration of
> the upgrade.

I am afraid this workaround may not be suitable for our case because of certain security consideration.

Best regards,
Ken

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: PostgreSQL 14.4 ERROR: out of memory issues
Next
From: Laurenz Albe
Date:
Subject: Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters