Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade 13.6 to 15.1? - Mailing list pgsql-general

From Alan Hodgson
Subject Re: pg_upgrade 13.6 to 15.1?
Date
Msg-id 69a8f73e58126f8f70f9c51a8289ff99f466ef89.camel@lists.simkin.ca
Whole thread Raw
In response to Re: pg_upgrade 13.6 to 15.1?  (pf@pfortin.com)
List pgsql-general
Tree view
On Sun, 2023-01-15 at 16:59 -0500, pf@pfortin.com wrote:


encodings for database "template1" do not match:  old "UTF8", new
"SQL_ASCII" Failure, exiting

You almost certainly don't want your new database to use SQL_ASCII. Init the new cluster with -E UTF8.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
Next
From: Gavan Schneider
Date:
Subject: Re: pg_upgrade 13.6 to 15.1?