| From: | "Tom Kinard" <tkinard(at)escloyalty(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Database Restore errors |
| Date: | 2006-07-26 13:50:24 |
| Message-ID: | 2FC74507639B244ABEBDF7FD6FBB44A704B29BF9@mail.4esc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am attempting to restore a database.
When I run pg_restore I get the following error:
Pg_restore: [archiver (db)] error returened by PQendcopy: ERROR: invalid
byte sequence for encoding "UTF8" : 0x92
The dump was generated on a Mac and I am doing a restore on a Fedora Core 4
box.
The dump was done using a tar format.
The restore command I used is a follows:
pg_restore -d bugs -U bugs -Ft bugs-backup
I am running version 8.1.4.
The output of psql -U bugs -c 'show client_encoding' is
UTF8
Local give items like
LANG=:en_US, UTF-8"
LC_COLLATE="en_US, UTF-8"
Any help will be greatly appreciated.
Tom Kinard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-07-26 13:54:40 | Re: sequences vs oids as primary keys |
| Previous Message | Kenneth Downs | 2006-07-26 11:48:19 | Re: Constraint on an aggregate? (need help writing trigger, |