Ok, that did it. Thank you for the help.
Tomasz Ostrowski wrote:
On Wed, 23 Jan 2008, Tom Hart wrote:
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
for encoding "UTF8": 0xc52f
Try editing your dump-file and change the line which reads "SET
client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';"
I tried making the changes you specified with notepad, wordpad, gVim, vim
and emacs and in each case pgAdmin (and pg_restore) complain about the dump
header being corrupted.
Try an "-E LATIN1" option in pg_dump. Do you at least know what is
the encoding of data in the database?
Regards
Tometzky
--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
