Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_upgrade 13.6 to 15.1?
Date
Msg-id 1743971.1673822241@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade 13.6 to 15.1?  (pf@pfortin.com)
List pgsql-general
Tree view 
pf@pfortin.com writes:
> encodings for database "template1" do not match:  old "UTF8", new
> "SQL_ASCII" Failure, exiting

So you need to do the initdb under the same locale setting you
used for the old DB.  Looking into its LC_XXX settings should
refresh your memory on what that was.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
Next
From: pf@pfortin.com
Date:
Subject: Re: pg_upgrade 13.6 to 15.1? [Solved: what can go wrong, will...]