<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=Windows-1252"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Hi Robert, I faced the same issues (I think) - if I remember correctly; I think I faked it, by installing Postgres 8.x (from the default repos) then getting 9.1 (for me) from postgres-repos and then (re-)moving/hiding the 8.4 binaries. Needed to take care of a bunch of Jars (9.x connectors etc) but that was it... If you want more details, I might be able to tell you on Monday... Best -Jonathan On 07/24/2014 04:38 PM, Boyd, Robert wrote: </div> <blockquote cite="mid:0D5F32BB8C49D6438AF012955D0CBEF2B8B13957E7@CORP2K7MAIL.corp.peopleclick.com" type="cite"> <meta http-equiv="Context-Type" content="text/html; charset=Windows-1252"> <meta name="Generator" content="Microsoft Word 12 (filtered medium)"> <div class="WordSection1"> Bedankt for the suggestion Andreas, It appears that someone previously – in 2012 logged a report about this very same problem with the installation procedure. The installation guide on the wiki states: “Spacewalk uses database server to store its primary data. It supports either PostgreSQL (version 8.4 and higher) or Oracle RDBMS (version 10g or higher).” Unfortunately the rpm needs some help to differentiate when something higher than 8.4 is actually installed. As far as I can tell from what I read in the response to the bug report, the problem is that the RPM is looking for 8.4 specific files and needs to be updated to include handling the changes implemented for 9 and above. Creating and managing RPMs is not in my current skillset – I would rather not spend my time learning how to do that when I won’t be doing that as a regular thing. It looks like I’d have to find the source of the spacewalk rpm to discover exactly how it’s coded and how it’s specifying the postgresql dependencies. Then I could put together a fakeout rpm as a companion to the postgresql9x rpms that would provide the missing metadata to fake out the spacewalk rpm. Seems like it would be a much easier effort for someone already well familiar with the spacewalk rpm construction to make the mods necessary to handle postgresql9x. <div> Robert Boyd Sr. Systems Engineer PeopleFluent p. 919-645-2972 | c. 919-306-4681 e. <a moz-do-not-send="true" href="mailto:robert.boyd@peoplefluent.com">Robert.Boyd@PeopleFluent.com</a> </div> <table class="MsoNormalTable"> <tbody> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> <a moz-do-not-send="true" href="http://www.peoplefluent.com/"><img id="Picture_x0020_1" src="cid:part2.00020804.03000003@helmholtz-muenchen.de" alt="http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png" height="62" width="150"></a> </td> </tr> </tbody> </table> <table class="MsoNormalTable"> <tbody> <tr> <td> Visit: <a moz-do-not-send="true" href="http://www.peoplefluent.com/">www.peoplefluent.com</a> | Read: <a moz-do-not-send="true" href="http://peoplefluent.com/resources/peoplefluent-blog">Peoplefluent Blog</a> | Follow: <a moz-do-not-send="true" href="http://twitter.com/peoplefluent">@peoplefluent</a> | Download: <a moz-do-not-send="true" href="http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8">iPad App</a> </td> </tr> </tbody> </table> <div> <div> From: <a class="moz-txt-link-abbreviated" href="mailto:spacewalk-list-bounces@redhat.com"> spacewalk-list-bounces@redhat.com</a> [<a class="moz-txt-link-freetext" href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Andreas Dijkman Sent: Thursday, July 24, 2014 3:12 AM To: <a class="moz-txt-link-abbreviated" href="mailto:spacewalk-list@redhat.com"> spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] upgrading postgres (8.4 > 9.x) on the spacewalk server ? </div> </div> Hi, <div> </div> <div> The RPM isn’t actually looking at the file but at the file specs of all available RPM’s. You need to install and rpm that provides the binary /usr/bin/psql in it’s metadata. You could build an metadata-only-rpm that depends on all the postgresql-9.x-stuff and provides the necessary files in it’s metadata and secretly creates symlinks underneath. </div> <div> <div> <div> <div> <div> Met vriendelijke groet, Andreas Dijkman Oracle Technical Consultant Phone: +31(0)50-210 0132 | Mobile: +31(0)6-8115 2982 </div> <div> <a moz-do-not-send="true" href="http://www.cygnis.nl/">Cygnis</a> | Stationsweg 3B | 9726 AC Groningen </div> <div> Op maandag afwezig </div> </div> </div> </div> <div> <div> On 23 Jul, 2014, at 23:42 , Boyd, Robert <<a moz-do-not-send="true" href="mailto:Robert.Boyd@peoplefluent.com">Robert.Boyd@peoplefluent.com</a>> wrote: </div> I tried changing the link for /usr/bin/psql to directly link to the binary. That didn't help. I tried removing the link and copying the binary to /usr/bin/psql -- that didn't help either. I take it this means that the error message I'm getting isn't telling me the truth about what the real error is. Robert Boyd Sr. Systems Engineer PeopleFluent p. 919-645-2972 | c. 919-306-4681 e. <a moz-do-not-send="true" href="mailto:Robert.Boyd@PeopleFluent.com">Robert.Boyd@PeopleFluent.com</a> -----Original Message----- From: Boyd, Robert Sent: Wednesday, July 23, 2014 5:33 PM To: '<a moz-do-not-send="true" href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>' Subject: RE: [Spacewalk-list] upgrading postgres (8.4 > 9.x) on the spacewalk server ? I'm attempting an install of spacewalk 2.2 using postgresql-9.3. I installed and manually configured postgresql. When I attempt to install spacewalk I get this error: yum install spacewalk-postgresql ... many dependencies resolved ... etc ... Error: Package: spacewalk-postgresql-2.2.2-1.el6.noarch (spacewalk) Requires: /usr/bin/psql However there is clearly something there: [root ~]# ll /usr/bin/psql lrwxrwxrwx. 1 root root 28 Jul 21 12:35 /usr/bin/psql -> /etc/alternatives/pgsql-psql [root ~]# ll /etc/alternatives/pgsql-psql lrwxrwxrwx. 1 root root 23 Jul 21 12:35 /etc/alternatives/pgsql-psql -> /usr/pgsql-9.3/bin/psql [root ~]# ll /usr/pgsql-9.3/bin/psql -rwxr-xr-x. 1 root root 447560 Mar 18 03:19 /usr/pgsql-9.3/bin/psql What is this package expecting to find there? Is a symbolic link not good enough? Can I fake it out by copying over the real binary or changing the link to point directly to the binary instead of an intermediate link? Robert Boyd Sr. Systems Engineer PeopleFluent p. 919-645-2972 | c. 919-306-4681 e. <a moz-do-not-send="true" href="mailto:Robert.Boyd@PeopleFluent.com">Robert.Boyd@PeopleFluent.com</a> _______________________________________________ Spacewalk-list mailing list <a moz-do-not-send="true" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a moz-do-not-send="true" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </div> </div> </div> </blockquote> <pre class="moz-signature" cols="72">-- Jonathan Hoser, M.Sc. Institute of Bioinformatics and System Biology WWW: <a class="moz-txt-link-freetext" href="http://mips.helmholtz-muenchen.de">http://mips.helmholtz-muenchen.de</a> </pre> <hr> Helmholtz Zentrum München Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH) Ingolstädter Landstr. 1 85764 Neuherberg www.helmholtz-muenchen.de Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe Geschäftsführer: Prof. Dr. Günther Wess, Dr. Nikolaus Blum, Dr. Alfons Enhsen Registergericht: Amtsgericht München HRB 6466 USt-IdNr: DE 129521671 </body> </html>