[Spacewalk-list] Problems with db import from oracle to postgres

[Silvio.Schanz at elektrobit.com]

Hi,

I tried to migrate our spacewalk server from oracle to postgres.
After 2 hours the import failed with these errors:
bash#  PGPASSWORD=***** psql -h localhost -U spaceuser spaceschema < spacewalk-oracle.dmp
...
DELETE 9
DELETE 0
DELETE 4
ERROR:  invalid byte sequence for encoding "UTF8": 0x00
HINT:  This error can also happen if the byte sequence does not match the encoding expT]ÂÂx10}ï°xèºÂÂwhich is controlled by "client_encoding".
CONTEXT:  COPY rhnpackagerepodata, line 1: "9   \x1fÂ\x08\x00\x00\x00\x00\x00\x00\x00                     ½I\x0aHÃnz[){7WýÂúT\x1..."

Can someone help me through this?

Thanks.

Regards,
   Silvio



----------------------------------------------------------------
Please note: This e-mail may contain confidential information
intended solely for the addressee. If you have received this
e-mail in error, please do not disclose it to anyone, notify
the sender promptly, and delete the message from your system.
Thank you.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110712/38a96fc9/attachment.htm>