Skip site navigation (1) Skip section navigation (2)

unable to restore 8.2.5

From: Tore Halset <halset(at)pvv(dot)ntnu(dot)no>
To: pgsql-admin(at)postgresql(dot)org
Subject: unable to restore 8.2.5
Date: 2008-09-19 08:29:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

I am having some trouble restoring a dump from the production system  
over to a test system. Both servers are 8.2.5 and both use UTF-8. The  
vrc_error table have ~36 mill rows on the production system, but none  
of those are restored to the test system.

pg_restore: [archiver (db)] Error from TOC entry 1665; 0 333256 TABLE  
DATA vrc_error primar
pg_restore: [archiver (db)] COPY failed: ERROR:  invalid byte sequence  
for encoding "UTF8": 0x81
HINT:  This error can also happen if the byte sequence does not match  
the encoding expected by the server, which is controlled by  
CONTEXT:  COPY vrc_error, line 34500528

Looks like I have managed to insert an illegal character into the main  
system that does not conform to UTF-8. Anything I can and should do to  
work around this issue?

Btw, we also use wal shipping and warm standby for the main database  
and that works perfect.

  - Tore.


pgsql-admin by date

Next:From: c kDate: 2008-09-19 11:55:23
Subject: Multi-processors
Previous:From: Bernt DrangeDate: 2008-09-19 08:26:44
Subject: Re: Regaining superuser access

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group