Re: Encoding error during database restore

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Paul Smith <paul(at)pscs(dot)co(dot)uk>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Encoding error during database restore
Date: 2021-11-05 05:14:54
Message-ID: 631ef09ca7455fec3c26d1dd914a71b669793ba5.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2021-11-04 at 15:58 +0000, Paul Smith wrote:
> On 03/11/2021 21:03, Marc Fromm wrote:
> > Is there an alternate way to set --locale=C using the “postgresql-setup --initdb --unit postgresql” command?
>
> have you tried using 'SQL_ASCII' instead of 'C'  for the locale?

That is very bad advice. Never use SQL_ASCII!

Yours,
Laurenz Albe

--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2021-11-05 19:10:21 pg_dump weirdness
Previous Message Nikhil Shetty 2021-11-05 05:02:04 Re: Stuck Checkpoint Process