|
|
|
|
|
|
| Author |
Message |
go *nix forums beginner
Joined: 10 Mar 2005
Posts: 14
|
Posted: Fri Mar 11, 2005 9:15 am Post subject:
pg_restore error
|
|
|
Hi All!
While restoring PG7.23 dump into PG 8.01 database
(pg_restore -Fc -d a3 -v arz3.test.dat) i got error:
pg_restore: ERROR: invalid byte sequence for encoding "UNICODE": 0xfc3535
CONTEXT: COPY mytable, line 9, column post3: "¦¦ 55146/23.12.04 "
pg_restore: [archiver (db)] error returned by PQendcopy
pg_restore: *** aborted because of error
Tell me please how to ignore all errors ?
Thanks
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
 |
Richard Huxton *nix forums Guru
Joined: 01 Mar 2005
Posts: 522
|
Posted: Fri Mar 11, 2005 9:44 am Post subject:
Re: pg_restore error
|
|
|
go wrote:
| Quote: | Hi All!
While restoring PG7.23 dump into PG 8.01 database
(pg_restore -Fc -d a3 -v arz3.test.dat) i got error:
pg_restore: ERROR: invalid byte sequence for encoding "UNICODE": 0xfc3535
CONTEXT: COPY mytable, line 9, column post3: "¦¦ 55146/23.12.04 "
pg_restore: [archiver (db)] error returned by PQendcopy
pg_restore: *** aborted because of error
Tell me please how to ignore all errors ?
|
With bad data? You can't. Are you sure the original database was UNICODE
(UTF8) and not SQL_ASCII encoding?
Try restoring into an SQL_ASCII version 8.0 database, then you can
correct your data and repeat the dump/import. Alternatively, you could
produce a text-file of the dump and correct it with perl/awk/etc.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend |
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|
|
The time now is Fri Jan 09, 2009 1:48 am | All times are GMT
|
|
Debt | MySpace Layouts | Credit Cards | Online MBA Degree | Overstock Coupons
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|