From: | "Woody Woodring" <george(dot)woodring(at)iglass(dot)net> |
---|---|
To: | "'Tom Kinard'" <tkinard(at)escloyalty(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Database Restore errors |
Date: | 2006-07-26 17:05:28 |
Message-ID: | 026201c6b0d5$b195e070$80b1a8c0@istructure.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am running into this issue as well. I am upgrading from 7.4.X to 8.1.4.
My databases were "ASCII" encoded in 7.4.X
I am editing the dumps to remove the non-UTF8 characters, but you could also
create your new db with "ASCII" encoding and it should import fine.
Hope this helps,
Woody
IGLASS Networks
_____
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Kinard
Sent: Wednesday, July 26, 2006 9:50 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Database Restore errors
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 | Redefined Horizons | 2006-07-26 18:09:22 | Database Design Theory - PostgreSQL Custom Types |
Previous Message | Michael Fuhr | 2006-07-26 17:03:57 | Re: wrong timestamp |