Re: [Spacewalk-list] install packages when migrating from oracle to postgres
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 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 < > waldi...@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 > 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@redhat.com >> https://www.redhat.com/mailman/listinfo/spacewalk-list >> > > ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] install packages when migrating from oracle to postgres
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 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 > 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@redhat.com >> https://www.redhat.com/mailman/listinfo/spacewalk-list___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] install packages when migrating from oracle to postgres
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 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@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] install packages when migrating from oracle to postgres
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@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list