[Spacewalk-list] Migrate from Oracle XE to postgres possible?

[Wojtak, Greg (Superfly)]

On 2012-05-24 2:13 AM, "Jan Pazdziora" <jpazdziora at redhat.com> wrote:

>On Wed, May 23, 2012 at 04:07:03PM -0500, Sean Carolan wrote:
>>Has anyone attempted this?  When we first installed Spacewalk the
>>postgres support was not stable so we went with Oracle XE instead, but
>>the situation seems to have improved.
>>Might there be a migration script or other process for migrating from
>>Oracle XE to PostgreSQL?
>
>Sure, the process is well documented and it was done by many Spacewalk
>admins, judging by some posts on the mailing lists. Please follow
>
>	https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle
>
>--
>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
>



+1

I had a little trepidation at doing the migration, but I followed the
steps closely, made sure I had backups and dumps of the database, and it
went very smoothly.


Greg Wojtak
Sr. Unix Systems Engineer
Office: (313) 373-4306
Cell: (734) 718-8472