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

[Waldirio Manhães Pinheiro]

Hello

That said, I believe you can do a fresh installation pointing to your
external db, and after that, just restore using db-control.

Everything should work as expected.

Sorry, didn't get time to check the wiki yet.

______________
Best
Waldirio
Skype: waldirio
Site: www.waldirio.com.br
LinkedIn: https://www.linkedin.com/in/waldirio


On Wed, Sep 25, 2019 at 11:14 AM spaceywalkey <spaceywalkey at protonmail.com>
wrote:

> 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/8df851d0/attachment.htm>