Problem restoring a table from 7.2.1 to 7.3.2

From: Kris Kiger <kris(at)musicrebellion(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem restoring a table from 7.2.1 to 7.3.2
Date: 2003-04-25 20:45:28
Message-ID: 3EA99E68.9080004@musicrebellion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have sucessfully dumped a table from my 7.2.1 database with:

pg_dump -t table1 -D -U postgres -Ft main > table1.tar

I am trying to use pg_restore to put this table into a 7.3.2 database with:

pg_restore -t table1 -d databaseX -v -Ft -U postgres table1.tar

However I am recieving this error:

pg_restore: connecting to database for restore
pg_restore: creating TABLE table1
pg_restore: connecting to database databaseX as user meep
pg_restore: restoring data for table table1
pg_restore: [archiver (db)] could not execute query: ERROR: Invalid
UNICODE character sequence found (0xd141)
pg_restore: *** aborted because of error

I understand the error, but I do not understand why there may be an
invalid unicode character present. The database I am moving from
(7.2.1) stores text as unicode.

The table restores the first 852 items in the table, so I un-tarred the
dump and took a look at the 853 insert. It looked fine to me, so I
pasted the insert into psql and it processed just fine. No invalid
unicode character exception thrown. Maybe I'm looking at this the wrong
way, but I'm out of ideas. Thanks for the help!

Kris

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-04-25 20:56:33 Re: After restoring a database using pg_restore , cannot insert or update records in tables with primary keys
Previous Message mallah 2003-04-25 20:09:18 Re: MAX CONNECTIONS PROBLEM