[Spacewalk-list] install packages when migrating from oracle to postgres

[spaceywalkey]

Hi,

Thanks for your reply. Sorry but I forgot to mention that I'm migrating from an external oracle database to an external postgresql database. Also, I've already got the 2.4 schema on the existing oracle db so no schema upgrades need to be done.

Thanks for your time,
Spacey

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Wednesday, September 25, 2019 1:53 PM, Waldirio Manhães Pinheiro <waldirio at gmail.com> wrote:

> Hello
>
> I'm not totally aware of this guide, however, one plan that I believe to be great should be
>
> 1. Do an online backup from your current installation
> 2. Install the fresh one using embedded db (PG) "I believe you are planning to use embedded". SW in the same version as the original
> 3. Restore the DB using db-control
>
> After that, you should be able to see the entire content and your SW should be working fine. After that, just the upgrade process as usual.
>
> Ps.: I'll take a look on the link ASAP.
> ______________
> Best
> Waldirio
> Skype: waldirio
> Site: www.waldirio.com.br
> LinkedIn: https://www.linkedin.com/in/waldirio
>
> On Wed, Sep 25, 2019 at 10:38 AM spaceywalkey <spaceywalkey at protonmail.com> wrote:
>
>> Hi,
>> I need to migrate the spacewalk backend from oracle to postgres. I'm currently using spacewalk2.4 on oracle linux and I'm going through this doc for the migration:
>>
>> https://github.com/spacewalkproject/spacewalk/wiki/DatabaseMigrations
>>
>> However, in the Prepare New Database section, I need to install and remove some rpms:
>>
>> yum remove -y spacewalk-oracle && yum install -y spacewalk-postgresql && yum remove -y spacewalk-java-oracle spacewalk-backend-sql-oracle
>>
>> Whats the suggested method for doing this? From the instructions, spacewalk will be down at this step. Do I download the rpms locally using yum-downloadonly? I tried that but it complains because spacewalk-postgresql and spacewalk-oracle conflict with each other and it looks like downloadonly won't
>>
>> Or maybe download the oracle linux spacewalk-2.4 rpms onto a different host? I'd prefer not to do this if there are alternatives
>>
>> Thanks
>> Spacey
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20190925/0ce043ef/attachment.htm>