| 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: | 35E76852-E52D-4BE7-9931-7B1AE6805248@pvv.ntnu.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello.
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
"client_encoding".
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.
Regards,
- Tore.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | c k | 2008-09-19 11:55:23 | Multi-processors |
| Previous Message | Bernt Drange | 2008-09-19 08:26:44 | Re: Regaining superuser access |