<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style></style> </head> <body lang="FR" link="blue" vlink="purple"> <div class="WordSection1"> <p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hello<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p> <p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’m very interesting about your migration. Could you please give your feedback when your database migration will be done ?<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p> <p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thanks<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p> <p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] <b>De </b></span><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">la part de</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Krzysztof Pawlowski<br> <b>Envoyé :</b> mercredi 19 novembre 2014 15:41<br> <b>À :</b> spacewalk-list@redhat.com<br> <b>Objet :</b> Re: [Spacewalk-list] Migration from pgsql to oracle<o:p></o:p></span></p> <p class="MsoNormal"><o:p> </o:p></p> <div> <div> <p class="MsoNormal" style="margin-bottom:12.0pt">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 ?<o:p></o:p></p> </div> <p class="MsoNormal">We have oracle support so another instance is not a problem for us. I'll try test export import with db-control.<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> <div> <p class="MsoNormal">2014-11-19 12:54 GMT+01:00 Waldirio Manhães Pinheiro <<a href="mailto:waldirio@gmail.com" target="_blank">waldirio@gmail.com</a>>:<o:p></o:p></p> <div> <p class="MsoNormal">Hello Krzysztof,<o:p></o:p></p> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> <div> <p class="MsoNormal">I see, I've one question for you.<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> <div> <p class="MsoNormal">1. Why do you want change from postgresql to Oracle db ?!, do you have Oracle support !? Just because I'm curious :-)<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> <div> <p class="MsoNormal">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.<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> <div> <p class="MsoNormal">Let me know if you have any doubt about it.<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> </div> <div> <p class="MsoNormal"><br clear="all"> <o:p></o:p></p> <div> <div> <div> <p class="MsoNormal">______________<br> Atenciosamente<br> Waldirio<br> msn: <a href="mailto:waldirio@gmail.com" target="_blank">waldirio@gmail.com</a><br> Skype: waldirio<br> Site: <a href="http://www.waldirio.com.br" target="_blank">www.waldirio.com.br</a><br> Blog: <a href="http://blog.waldirio.com.br" target="_blank">blog.waldirio.com.br</a><o:p></o:p></p> </div> <div> <p class="MsoNormal">LinkedIn: <a href="http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646" target="_blank"> http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646</a><br> PGP: <a href="http://www.waldirio.com.br/public.html" target="_blank">www.waldirio.com.br/public.html</a><o:p></o:p></p> </div> </div> </div> <p class="MsoNormal"><o:p> </o:p></p> <div> <div> <div> <p class="MsoNormal">On Wed, Nov 19, 2014 at 9:20 AM, Krzysztof Pawłowski <<a href="mailto:msciciel@msciciel.eu" target="_blank">msciciel@msciciel.eu</a>> wrote:<o:p></o:p></p> <div> <p class="MsoNormal">I know that I can but problem is that my spacewalk has 1000+ clients and is using pgsql as db backend now. <o:p></o:p></p> </div> <div> <div> <div> <p class="MsoNormal"><o:p> </o:p></p> <div> <p class="MsoNormal">2014-11-19 12:08 GMT+01:00 Waldirio Manhães Pinheiro <<a href="mailto:waldirio@gmail.com" target="_blank">waldirio@gmail.com</a>>:<o:p></o:p></p> <div> <p class="MsoNormal">Hello Krzysztof, good morning<o:p></o:p></p> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> <div> <p class="MsoNormal">you can use Oracle as backend (<a href="https://fedorahosted.org/spacewalk/wiki/HowToInstall#Databaseserver" target="_blank">https://fedorahosted.org/spacewalk/wiki/HowToInstall#Databaseserver</a>)<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> <div> <p class="MsoNormal">B'Regards<o:p></o:p></p> </div> <div> <p class="MsoNormal"><o:p> </o:p></p> </div> </div> <div> <p class="MsoNormal"><br clear="all"> <o:p></o:p></p> <div> <div> <div> <p class="MsoNormal">______________<br> Atenciosamente<br> Waldirio<br> msn: <a href="mailto:waldirio@gmail.com" target="_blank">waldirio@gmail.com</a><br> Skype: waldirio<br> Site: <a href="http://www.waldirio.com.br" target="_blank">www.waldirio.com.br</a><br> Blog: <a href="http://blog.waldirio.com.br" target="_blank">blog.waldirio.com.br</a><o:p></o:p></p> </div> <div> <p class="MsoNormal">LinkedIn: <a href="http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646" target="_blank"> http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646</a><br> PGP: <a href="http://www.waldirio.com.br/public.html" target="_blank">www.waldirio.com.br/public.html</a><o:p></o:p></p> </div> </div> </div> <p class="MsoNormal"><o:p> </o:p></p> <div> <p class="MsoNormal">On Wed, Nov 19, 2014 at 7:42 AM, Krzysztof Pawłowski <<a href="mailto:msciciel@msciciel.eu" target="_blank">msciciel@msciciel.eu</a>> wrote:<o:p></o:p></p> <div> <p class="MsoNormal">Is there any way to switch db backend to oracle ?<o:p></o:p></p> </div> <p class="MsoNormal"><br> _______________________________________________<br> Spacewalk-list mailing list<br> <a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></p> </div> <p class="MsoNormal"><o:p> </o:p></p> </div> <p class="MsoNormal"><br> _______________________________________________<br> Spacewalk-list mailing list<br> <a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></p> </div> <p class="MsoNormal"><o:p> </o:p></p> </div> </div> </div> <p class="MsoNormal"><br> _______________________________________________<br> Spacewalk-list mailing list<br> <a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></p> </div> <p class="MsoNormal"><o:p> </o:p></p> </div> </div> </div> <p class="MsoNormal"><br> _______________________________________________<br> Spacewalk-list mailing list<br> <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></p> </div> <p class="MsoNormal"><o:p> </o:p></p> </div> </div> <br> <hr> <font face="Arial" color="Gray" size="1"><br> 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.<br> <br> 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.<br> </font> </body> </html>