On 3/15/20 9:18 PM, Samuel Smith wrote:
> My current DB backup routine is just to call pg_dump and pipe to gzip.
> We recently started to get a failure to restore (which is basically just
> using psql -f on the pg_dump file) with the following errors:
>
> invalid byte sequence for encoding "UTF8": 0xa0
> and
> invalid byte sequence for encoding "UTF8": 0xd7 0x20
>
>
> This is on a pg 9.2.24 instance. Any tips to troubleshoot?
What are the locale and encodings set to for the instance and databases
in it?
>
> Regards,
> Samuel Smith
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com