niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » PostgreSQL
pg_restore error
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
go
*nix forums beginner


Joined: 10 Mar 2005
Posts: 14

PostPosted: Fri Mar 11, 2005 9:15 am    Post subject: pg_restore error Reply with 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 ?

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

PostPosted: Fri Mar 11, 2005 9:44 am    Post subject: Re: pg_restore error Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Fri Jan 09, 2009 1:48 am | All times are GMT
navigation Forum index » Databases » PostgreSQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Postfix + MySQL error: very strange variable %s iWarior Postfix 0 Mon Aug 25, 2008 2:01 pm
No new posts ** Postfix error on console every minute or so ** ?? drywash Postfix 0 Fri Jul 04, 2008 8:49 pm
No new posts Postfix error bounce diwash Postfix 0 Fri Mar 28, 2008 3:37 am
No new posts I am getting following error in Aix 5.3 rockcharles1 AIX 0 Tue Aug 28, 2007 11:06 pm
No new posts postfix out of memory error - please help metind Postfix 0 Mon Sep 11, 2006 1:54 am

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
[ Time: 0.1628s ][ Queries: 16 (0.0855s) ][ GZIP on - Debug on ]