[Spacewalk-list] Migration from pgsql to oracle

[Krzysztof Pawłowski]

Ofcourse. But i'll will be planned propably for january. I'll give feedback
if we encounter problems or not.

2014-11-19 15:49 GMT+01:00 Nahelou Sébastien <
sebastien.nahelou at worldline.com>:

>  Hello
>
>
>
> I’m very interesting about your migration. Could you please give your
> feedback when your database migration will be done ?
>
>
>
> Thanks
>
>
>
> *De :* spacewalk-list-bounces at redhat.com [mailto:
> spacewalk-list-bounces at redhat.com] *De **la part de* Krzysztof Pawlowski
> *Envoyé :* mercredi 19 novembre 2014 15:41
> *À :* spacewalk-list at redhat.com
> *Objet :* Re: [Spacewalk-list] Migration from pgsql to oracle
>
>
>
> 1. I read that oracle is performing much better in bigger spacewalk
> deployment. I have 1600 clients connected to spacewalk and is impossible to
> schedule tasks on all hosts. My db team said that pgsql is limited to
> single core per connections which means that spacewalk cannot utilize db in
> more efficient way. Maybe (I hope) i'm not aware of configuration options
> which make this possible ?
>
> We have oracle support so another instance is not a problem for us. I'll
> try test export import with db-control.
>
>
>
> 2014-11-19 12:54 GMT+01:00 Waldirio Manhães Pinheiro <waldirio at gmail.com>:
>
> Hello Krzysztof,
>
>
>
> I see, I've one question for you.
>
>
>
> 1. Why do you want change from postgresql to Oracle db ?!, do you have
> Oracle support !? Just because I'm curious :-)
>
>
>
> What you can do is, build a new machine with SW and Oracle to test, export
> from SW with postgresql using db-control and import in SW with Oracle using
> db-control. In theory, the data model is the same changing only the sgdb,
> so will not get problem about data.
>
>
>
> Let me know if you have any doubt about it.
>
>
>
>
>   ______________
> Atenciosamente
> Waldirio
> msn: waldirio at gmail.com
> Skype: waldirio
> Site: www.waldirio.com.br
> Blog: blog.waldirio.com.br
>
> LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
> PGP: www.waldirio.com.br/public.html
>
>
>
> On Wed, Nov 19, 2014 at 9:20 AM, Krzysztof Pawłowski <msciciel at msciciel.eu>
> wrote:
>
> I know that I can but problem is that my spacewalk has 1000+ clients and
> is using pgsql as db backend now.
>
>
>
> 2014-11-19 12:08 GMT+01:00 Waldirio Manhães Pinheiro <waldirio at gmail.com>:
>
> Hello Krzysztof, good morning
>
>
>
> you can use Oracle as backend (
> https://fedorahosted.org/spacewalk/wiki/HowToInstall#Databaseserver)
>
>
>
> B'Regards
>
>
>
>
>   ______________
> Atenciosamente
> Waldirio
> msn: waldirio at gmail.com
> Skype: waldirio
> Site: www.waldirio.com.br
> Blog: blog.waldirio.com.br
>
> LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
> PGP: www.waldirio.com.br/public.html
>
>
>
> On Wed, Nov 19, 2014 at 7:42 AM, Krzysztof Pawłowski <msciciel at msciciel.eu>
> wrote:
>
> Is there any way to switch db backend to oracle ?
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> ------------------------------
>
> Ce message et les pièces jointes sont confidentiels et réservés à l'usage
> exclusif de ses destinataires. Il peut également être protégé par le secret
> professionnel. Si vous recevez ce message par erreur, merci d'en avertir
> immédiatement l'expéditeur et de le détruire. L'intégrité du message ne
> pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra
> être recherchée quant au contenu de ce message. Bien que les meilleurs
> efforts soient faits pour maintenir cette transmission exempte de tout
> virus, l'expéditeur ne donne aucune garantie à cet égard et sa
> responsabilité ne saurait être recherchée pour tout dommage résultant d'un
> virus transmis.
>
> This e-mail and the documents attached are confidential and intended
> solely for the addressee; it may also be privileged. If you receive this
> e-mail in error, please notify the sender immediately and destroy it. As
> its integrity cannot be secured on the Internet, the Worldline liability
> cannot be triggered for the message content. Although the sender endeavours
> to maintain a computer virus-free network, the sender does not warrant that
> this transmission is virus-free and will not be liable for any damages
> resulting from any virus transmitted.
>
> _______________________________________________
> 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/20141119/2fdc447f/attachment.htm>