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

[Jan Pazdziora]

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