Postgres Pro
Downloads
Home   >   mailing lists

Invalid byte sequence errors on DB restore - Mailing list pgsql-general

From Samuel Smith
Subject Invalid byte sequence errors on DB restore
Date
Msg-id 2c81203a-01ef-ca84-1294-91420f71dd1f@net153.net
Whole thread Raw
Responses Re: Invalid byte sequence errors on DB restore  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Invalid byte sequence errors on DB restore  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Invalid byte sequence errors on DB restore  (Samuel Smith <pgsql@net153.net>)
List pgsql-general
Tree view 
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?

Regards,
Samuel Smith

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Order by and timestamp
Next
From: Laurenz Albe
Date:
Subject: Re: Invalid byte sequence errors on DB restore