Am 21. August 2017 19:49:49 MESZ schrieb Sean Roe :
>I found a solution that I am sharing with you. Because the linux
>postgresql database would barf on the ALF32UTF8 input file generated by
>doing the spacewalk-dump-schema command I had to take the output from
>that command and I ran it through the following command:
>
>iconv -c -t utf-8 migrate-to-postgres.sql > migrate-to-postgres2.sql
>
>and then do the:
>
>spacewalk-sql -verbose migrate-to-postgres2.sql
>
>Just thought I would share my solution.
>
>Thanks,
>Sean
>
>From: spacewalk-list-boun...@redhat.com
>[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Sean Roe
>Sent: Friday, August 18, 2017 8:45 AM
>To: spacewalk-list@redhat.com
>Subject: [Spacewalk-list] Migration question
>
>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
Hi Sean,
thank you for this information. I appreciate it.
Robert
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
