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

[Silvio.Schanz at elektrobit.com]

Hi Jan,

This is my output from 
fgrep rhnpackagerepodata spacewalk-oracle.dmp
..
copy rhnpackagerepodata(package_id,primary_xml,filelist,other,created,modified) from stdin; 9 \x1fÂ\x08\x00\x00\x00\x00\x00\x00\x00                     ½I\x0aHÃnz[){7WýÂúT\x193Â\x1b¹¶a7ýõ\x1dCÂÂ¥jÃÃx17ÂñÂ9ÂÂ3°¦lGs f_C䨺tâ°¢%Ã
                                                                                                                                                          5(1^?ÂOÂ\x0b=Ãîò\x1bYe<\x0f½Ã\x1bRÃ
¸Âö'ô:#lAi.+¿Â3u'\x0bÂ(\x10ö/¹C Â¬ÂÂÂãÃ
!+ÂítS\x1e®-Sôû§ÂóeýÃÂÂnðlO\x10LÂÃ¥lT-5ÃÃÂ0YÃ\x5cð*'4§6ÂÃÃ\x06W;{Âib@éÂFïV§Â\x13®\x09µ]ÃbäI·Ã±1B²^ÃBA\x1699ÂmOà ]\x18ÿ±ÂaS!Ãü½Ã\x13¸ÂÃ(\x1fC©ÃK;bÃ$­ÂíPOô\x14Ã\x11\x15@ññ¢\x15. ÃEÂÃ\x09Â\x09®Â\x0aõ\x09¦A`\x1bkÂø$[£Ã[X\x1b¾\x05»Â"æðâãyéÂLÃ\x5cGÃúÃÃî\x19,'ï<ÃÂzþÂj¸çÂÃû5e\x05ÿ5\x5cÂi¹º»¿ý´½¹¿þùøuî.ÃÃ
ÃÂèÂ*}Ã{CU}ëq½3sÿÃû}wÂóg\x01­\x13óÃÂXÂh)õ½ã&ð\x0eÃ(þ\x01Â{EÃe\x07\â\x17ä=î\x0b\x0ckcáfÃá²»­ÃÃ,îáÃ\x07\x0d¦Â·Ãï¡Â\x1fEõ£ÿÃ÷¢ÂOÃÃ)OÂÂþÃtȈ \x0ct±ç\x10HÂ\x01\x1dQ_4FO ÃwFïÃñ\x00Âyæá=øÂò\x09w¢<\x072\x19Â\x09·UueÃÃà                                                                µt{ì¶=¬~~Zþõþ5ÂÃÂ\x006¦\x0b§d4Â\x16¨Kæ\x04±sÂññÃLÂpÂÃ\x1aø®Ã#*+à BȑÃÂ
í:¬q³\x01\x1e±Â%\x07¸Ãá?Ãÿ\x01/Â{,©\x05\x00\x00   2010-07-22 12:13:00 2010-07-22 12:13:00
..

Regards,
  Silvio

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Tuesday, July 12, 2011 2:36 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Problems with db import from oracle to postgres

On Tue, Jul 12, 2011 at 12:16:21PM +0000, Silvio.Schanz at elektrobit.com wrote:
> 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?

What does the

	-- Types for rhnpackagerepodata

line in the spacewalk-oracle.dmp say?

--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list


----------------------------------------------------------------
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.