Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters

From: Ken Yeung <Ken(dot)Yeung(at)rib-software(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters
Date: 2022-07-13 02:53:30
Message-ID: VI1PR01MB49268B47C0985A4D249485A0C0899@VI1PR01MB4926.eurprd01.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2022-07-13 05:49:54 Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters
Previous Message Michael Paquier 2022-07-13 00:20:51 Re: PostgreSQL 14.4 ERROR: out of memory issues