Hi All,

I have updated my spacewalk install to 2.6 and it appears to be running fine at 
this point.  We wish to migrate it off of Oracle and on to its own internal 
postgres instance.  I am following the document 
https://github.com/spacewalkproject/spacewalk/wiki/DatabaseMigrations and I 
have completed the dump of the database using



spacewalk-dump-schema --to=postgresql > blahblahblah.sql .



When I went to import it into postgres it appears there is some 
incompatibilities between AL32UTF8 and UTF8.  It appears to be an issue with 
\x0a characters in the data.  Has anybody come across this and how did they 
solve it?  Right now I am running the dump through sed like this:



sed 's/\\x0a/\\N/g' blahblahblah.sql  > postconv.sql



Any input would be helpful.



Thanks,

Sean
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to