[Spacewalk-list] Please help with Oracle to PostgreSQL migration

[Jan Pazdziora]

On Mon, Dec 19, 2011 at 04:05:43PM -0800, James Fillman wrote:
> Hi Jan,
> 
> Thanks for getting back to me. I'm amazed at how you manage to reply to just about every posting on the spacewalk-list.
> 
> I put VI to work and edited my 4.5 GB dump file. I did find 2 illegal chars on line 136452. Not sure how they got past the code mentioned in the email but all was well after I deleted the unwanted chars.
> 

So what did the line look like exactly?

>    return self._execute_(args, kwargs)
>   File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 277, in _execute_
>     self._real_cursor.execute(self.sql, params)
> DataError: invalid input syntax for type bytea at character 115

I believe Michael fixed this recently in Spacewalk nightly,

	https://www.redhat.com/archives/spacewalk-list/2011-December/msg00056.html

Yours,

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