Invalid byte sequence errors on DB restore

From: Samuel Smith <pgsql(at)net153(dot)net>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Invalid byte sequence errors on DB restore
Date: 2020-03-16 04:18:35
Message-ID: 2c81203a-01ef-ca84-1294-91420f71dd1f@net153.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-03-16 07:49:18 Re: Invalid byte sequence errors on DB restore
Previous Message Tom Lane 2020-03-16 00:41:03 Re: Order by and timestamp