<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=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style></style></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1>I found some more things that need tweaking.<o:p></o:p><o:p> </o:p>/etc/sysconfig/rhn/postgres/deploy.sql refers to /usr/share/pgsql/contrib/dblink.sql which doesn’t exist in postgresql-9.3 in that location. The new location is: /usr/pgsql-9.3/share/extension/dblink--1.1.sql <o:p></o:p>I haven’t worked out the format of how that could be fixed inside the deploy script since I’m not a SQL programmer. And this script seems to be generated on the fly, so I’m unsure as to where it’s coming from.<o:p></o:p><o:p> </o:p>As suggested by someone else I did go into /etc/sysconfig/rhn/postgres/main.sql and modify the problem line <o:p></o:p> <o:p></o:p> \i /usr/share/pgsql/contrib./dblink.sql <o:p></o:p>To<o:p></o:p>Create extension dblink;<o:p></o:p><o:p> </o:p>It would be nice to have the script autodetect the version and do the right thing.<o:p></o:p><o:p> </o:p>That got me to the point where I get errors with the tomcat start:<o:p></o:p><o:p> </o:p>java.io.IOException: Failed to access resource /WEB-INF/lib/jta.jar<o:p></o:p> at org.apache.catalina.loader.WebappLoader.setRepositories(WebappLoader.java:1022)<o:p></o:p> at org.apache.catalina.loader.WebappLoader.start(WebappLoader.java:653)<o:p></o:p><o:p> </o:p>So I rummaged around and found a suggestion to <o:p></o:p> Yum install geronimo-jta-1.1-api<o:p></o:p><o:p> </o:p>Also, I had to make more mods to /usr/bin/spacewalk-setup-postgresql and install the perl DBD postgresql module: yum install perl-DBD-Pg<o:p></o:p>I moved the version detection code block for postgres to an earlier point in the setup script and it now looks like this:<o:p></o:p><o:p> </o:p>def_regexes<o:p></o:p>unset -f def_regexes<o:p></o:p><o:p> </o:p>POSTGRES_SERVICE=postgresql<o:p></o:p> OIFS="$IFS"; IFS=' '; read pgsyn pgformal pgnums <<< "$(psql --version)" ; IFS="$OIFS"<o:p></o:p> OIFS="$IFS"; IFS='.'; read pgvermajor pgverminor pgverpoint <<< "${pgnums}" ; IFS="$OIFS"<o:p></o:p> case "$pgvermajor" in<o:p></o:p> 8)<o:p></o:p> PG_DATA=/var/lib/pgsql/data<o:p></o:p> ;;<o:p></o:p> *) POSTGRES_SERVICE=${POSTGRES_SERVICE}-${pgvermajor}.${pgverminor}<o:p></o:p> PG_DATA=/var/lib/pgsql/${pgvermajor}.${pgverminor}/data<o:p></o:p> ;;<o:p></o:p> esac<o:p></o:p>PG_HBA="$PG_DATA/pg_hba.conf"<o:p></o:p>PG_IDENT="$PG_DATA/pg_ident.conf"<o:p></o:p><o:p> </o:p>And the section I listed before has the version detection lifted out and is now just the version agnostic part:<o:p></o:p><o:p> </o:p>postgresql_service() {<o:p></o:p><o:p> </o:p> if [ -e "$SPACEWALK_TARGET" ] ; then<o:p></o:p> case $1 in<o:p></o:p> initdb) postgresql-setup initdb ;;<o:p></o:p> *) systemctl $1 ${POSTGRES_SERVICE} ;;<o:p></o:p> esac<o:p></o:p> else<o:p></o:p> case $1 in<o:p></o:p> enable) chkconfig ${POSTGRES_SERVICE} on ;;<o:p></o:p> *) service ${POSTGRES_SERVICE} $1 ;;<o:p></o:p> esac<o:p></o:p> fi<o:p></o:p>}<o:p></o:p><o:p> </o:p><div>Robert Boyd<o:p></o:p>Sr. Systems Engineer <o:p></o:p>PeopleFluent<o:p></o:p>p. 919-645-2972 | c. 919-306-4681<o:p></o:p>e. <a href="mailto:robert.boyd@peoplefluent.com">Robert.Boyd@PeopleFluent.com</a><o:p></o:p></div><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><a href="http://www.peoplefluent.com/"><img border=0 width=150 height=62 id="_x0000_i1030" src="cid:image001.png@01CFABFD.EB8EE5C0" alt="http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png"></a><o:p></o:p></td></tr></table><o:p> </o:p><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'> Visit: <a href="http://www.peoplefluent.com/">www.peoplefluent.com</a> | Read: <a href="http://peoplefluent.com/resources/peoplefluent-blog">Peoplefluent Blog</a> | Follow: <a href="http://twitter.com/peoplefluent">@peoplefluent</a> | Download: <a href="http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8">iPad App</a><o:p></o:p></td></tr></table><o:p> </o:p><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>From: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] On Behalf Of Boyd, Robert Sent: Tuesday, July 29, 2014 1:42 PM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Support for postgresql > 8.4<o:p></o:p></div></div><o:p> </o:p>Also found I needed to change this routine in /usr/bin/spacewalk-setup-postgresql<o:p></o:p><o:p> </o:p>postgresql_service() {<o:p></o:p> POSTGRES_SERVICE=postgresql<o:p></o:p> OIFS="$IFS"; IFS=' '; read pgsyn pgformal pgnums <<< "$(psql --version)" ; IFS="$OIFS"<o:p></o:p> OIFS="$IFS"; IFS='.'; read pgvermajor pgverminor pgverpoint <<< "${pgnums}" ; IFS="$OIFS"<o:p></o:p> case "$pgvermajor" in<o:p></o:p> 8)<o:p></o:p> ;;<o:p></o:p> *) POSTGRES_SERVICE=${POSTGRES_SERVICE}-${pgvermajor}${pgverminor}<o:p></o:p> ;;<o:p></o:p> esac<o:p></o:p><o:p> </o:p> if [ -e "$SPACEWALK_TARGET" ] ; then<o:p></o:p> case $1 in<o:p></o:p> initdb) postgresql-setup initdb ;;<o:p></o:p> *) systemctl $1 ${POSTGRES_SERVICE};;<o:p></o:p> esac<o:p></o:p> else<o:p></o:p> case $1 in<o:p></o:p> enable) chkconfig postgresql on ;;<o:p></o:p> *) service ${POSTGRES_SERVICE} $1 ;;<o:p></o:p> esac<o:p></o:p> fi<o:p></o:p>}<o:p></o:p><o:p> </o:p>After all those changes I did this:<o:p></o:p><o:p> </o:p>spacewalk-setup --disconnected --answer-file=/root/answer-files/spacewalk-configure --clear-db<o:p></o:p><o:p> </o:p>And presto! I have the service up and running and I managed to login and initialize the administrator account.<o:p></o:p><o:p> </o:p>Hopefully this will help someone else put all the pieces together, and maybe we can update the setup components to do these pieces automatically when PostgreSQL 9 or later is installed.<o:p></o:p><o:p> </o:p><div>Robert Boyd<o:p></o:p>Sr. Systems Engineer <o:p></o:p>PeopleFluent<o:p></o:p>p. 919-645-2972 | c. 919-306-4681<o:p></o:p>e. <a href="mailto:robert.boyd@peoplefluent.com">Robert.Boyd@PeopleFluent.com</a><o:p></o:p></div><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><a href="http://www.peoplefluent.com/"><img border=0 width=150 height=62 id="_x0000_i1025" src="cid:image001.png@01CFABFD.EB8EE5C0" alt="http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png"></a><o:p></o:p></td></tr></table><o:p> </o:p><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'> Visit: <a href="http://www.peoplefluent.com/">www.peoplefluent.com</a> | Read: <a href="http://peoplefluent.com/resources/peoplefluent-blog">Peoplefluent Blog</a> | Follow: <a href="http://twitter.com/peoplefluent">@peoplefluent</a> | Download: <a href="http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8">iPad App</a><o:p></o:p></td></tr></table><o:p> </o:p><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Boyd, Robert Sent: Friday, July 25, 2014 3:52 PM To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Support for postgresql > 8.4<o:p></o:p></div></div><o:p> </o:p>Here’s what I replaced it with:<o:p></o:p><o:p> </o:p>sub postgresql_start {<o:p></o:p> my $postgres_version = `psql --version`;<o:p></o:p> my ( $pName, $Official_Name, $pVersion ) = split " ", $postgres_version;<o:p></o:p> my ( $psql_Major,$psql_Minor,$psql_Point) = split /\./, $pVersion ;<o:p></o:p><o:p> </o:p>SWITCH: {<o:p></o:p> if ( $psql_Major =~ /8/) { $psql_service_name = "postgresql"; last SWITCH }<o:p></o:p> if ( $psql_Major =~ /9/) { $psql_service_name = "postgresql-".$psql_Major.$psql_Minor; last SWITCH }<o:p></o:p> }<o:p></o:p><o:p> </o:p> system('service $psql_service_name status >&/dev/null');<o:p></o:p> system('service $psql_service start >&/dev/null') if ($? >> 8);<o:p></o:p> return ($? >> 8);<o:p></o:p>}<o:p></o:p><o:p> </o:p>Monday I’ll be trying it out. I expect to find some issues in shell scripts that need the same kind of version detection.<o:p></o:p><o:p> </o:p><div>Robert Boyd<o:p></o:p>Sr. Systems Engineer <o:p></o:p>PeopleFluent<o:p></o:p>p. 919-645-2972 | c. 919-306-4681<o:p></o:p>e. <a href="mailto:robert.boyd@peoplefluent.com">Robert.Boyd@PeopleFluent.com</a><o:p></o:p></div><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><a href="http://www.peoplefluent.com/"><img border=0 width=150 height=62 id="_x0000_i1026" src="cid:image001.png@01CFABFD.EB8EE5C0" alt="http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png"></a><o:p></o:p></td></tr></table><o:p> </o:p><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'> Visit: <a href="http://www.peoplefluent.com/">www.peoplefluent.com</a> | Read: <a href="http://peoplefluent.com/resources/peoplefluent-blog">Peoplefluent Blog</a> | Follow: <a href="http://twitter.com/peoplefluent">@peoplefluent</a> | Download: <a href="http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8">iPad App</a><o:p></o:p></td></tr></table><o:p> </o:p><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Coffman, Anthony J Sent: Friday, July 25, 2014 12:54 PM To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Support for postgresql > 8.4<o:p></o:p></div></div><o:p> </o:p><a name="_MailEndCompose">Robert – just wanted to let you know I appreciate you blazing this trail. I’m watching this thread with interest. I want to make the same move with Postgres but don’t have a lot of time to invest in working through these issues.</a><o:p></o:p><o:p> </o:p>I think the relevant file is /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm<o:p></o:p><o:p> </o:p>It’s got these hardcoded service references<o:p></o:p><o:p> </o:p><o:p> </o:p>sub postgresql_start {<o:p></o:p> system('service postgresql status >&/dev/null');<o:p></o:p> system('service postgresql start >&/dev/null') if ($? >> 8);<o:p></o:p> return ($? >> 8);<o:p></o:p>}<o:p></o:p><o:p> </o:p><o:p> </o:p>--Tony<o:p></o:p><o:p> </o:p><o:p> </o:p><o:p> </o:p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'>From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Boyd, Robert Sent: Friday, July 25, 2014 11:28 AM To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Support for postgresql > 8.4<o:p></o:p></div></div><o:p> </o:p>I just re-read the report from 2012 and finally understood what Jan logged against that ticket:<o:p></o:p><o:p> </o:p>After re-reading that I did the following:<o:p></o:p><o:p> </o:p>yum deplist spacewalk-postgresql<o:p></o:p>Loaded plugins: downloadonly, product-id, refresh-packagekit, rhnplugin, security, subscription-manager<o:p></o:p>This system is receiving updates from Red Hat Subscription Management.<o:p></o:p>This system is receiving updates from RHN Classic or Red Hat Satellite.<o:p></o:p>rhel-6-server-extras-rpms | 2.6 kB 00:00 <o:p></o:p>rhel-6-server-optional-rpms | 3.5 kB 00:00 <o:p></o:p>rhel-6-server-rhn-tools-rpms | 2.9 kB 00:00 <o:p></o:p>rhel-6-server-rpms | 3.7 kB 00:00 <o:p></o:p>rhel-6-server-supplementary-rpms | 3.7 kB 00:00 <o:p></o:p>Finding dependencies: <o:p></o:p>package: spacewalk-postgresql.noarch 2.2.2-1.el6<o:p></o:p> dependency: /usr/bin/psql<o:p></o:p> Unsatisfied . dependency<o:p></o:p> dependency: postgresql >= 8.4<o:p></o:p> provider: postgresql93.x86_64 9.3.4-1PGDG.rhel6<o:p></o:p> provider: postgresql93.x86_64 9.3.3-1PGDG.rhel6<o:p></o:p> provider: postgresql93.x86_64 9.3.5-1PGDG.rhel6<o:p></o:p> dependency: postgresql-contrib >= 8.4<o:p></o:p> provider: postgresql93-contrib.x86_64 9.3.4-1PGDG.rhel6<o:p></o:p> provider: postgresql93-contrib.x86_64 9.3.5-1PGDG.rhel6<o:p></o:p> provider: postgresql93-contrib.x86_64 9.3.3-1PGDG.rhel6<o:p></o:p> dependency: spacewalk-common = 2.2.2-1.el6<o:p></o:p> provider: spacewalk-common.noarch 2.2.2-1.el6<o:p></o:p> dependency: perl(DBD::Pg)<o:p></o:p> provider: perl-DBD-Pg.x86_64 2.15.1-3.el6<o:p></o:p> provider: perl-DBD-Pg.x86_64 2.15.1-4.el6_3<o:p></o:p> provider: perl-DBD-Pg.x86_64 2.15.1-4.el6_3<o:p></o:p> provider: perl-DBD-Pg.x86_64 2.15.1-3.el6<o:p></o:p> dependency: spacewalk-backend-sql-postgresql<o:p></o:p> provider: spacewalk-backend-sql-postgresql.noarch 2.2.43-1.el6<o:p></o:p> dependency: spacewalk-java-postgresql<o:p></o:p> provider: spacewalk-java-postgresql.noarch 2.2.123-1.el6<o:p></o:p><o:p> </o:p>After this I manually selected the listed items: yum install postgresql93-contrib spacewalk-common perl-DBD-Pg spacewalk-backend-sql-postgresql spacewalk-java-postgresql <o:p></o:p><o:p> </o:p>If Jan’s statement about the master package is correct then I’ve successfully installed all of the components.<o:p></o:p><o:p> </o:p>I found the messages from the list about taking care of the jdbc and did all those fixes too. <o:p></o:p>From Paul Robert Marino:<o:p></o:p>Ok three things here<o:p></o:p>1) install the PostgreSQL 8 libraries and JDBC driver<o:p></o:p>2) make sure the PostgreSQL 9.2 JDBC driver is installed<o:p></o:p>3) fix the symlink for the jdbc driver to point to the the 9.2 version here is where it points to by default "<o:p></o:p># ls -l /usr/share/java/postgresql-jdbc.jar<o:p></o:p>lrwxrwxrwx. 1 root root 44 Nov 5 2012<o:p></o:p>/usr/share/java/postgresql-jdbc.jar -><o:p></o:p>/usr/share/java/postgresql-8.4-703.jdbc4.jar<o:p></o:p>"<o:p></o:p>you need to point it to the PostgreSQL 9.2 JDBC driver instead<o:p></o:p><o:p> </o:p>It would be nice if going forward all of this information is collected in 1 place as a set of notes for those choosing to install spacewalk with postgresql v9 or greater. Unless we’re only interested in everyone who follows after us having to feel the same pains.<o:p></o:p><o:p> </o:p>Now I’m trying to initialize spacewalk and here’s what I get:<o:p></o:p><o:p> </o:p>spacewalk-setup --disconnected --answer-file=answer-files/spacewalk-configure <o:p></o:p>* Loading answer file: answer-files/spacewalk-configure.<o:p></o:p>* Setting up SELinux..<o:p></o:p>** Database: Setting up database connection for PostgreSQL backend.<o:p></o:p>** Database: Installing the database:<o:p></o:p>** Database: This is a long process that is logged in:<o:p></o:p>** Database: /var/log/rhn/install_db.log<o:p></o:p>*** Progress: #<o:p></o:p>Could not install database.<o:p></o:p>[root@rdcengsw01 ~]# less /var/log/rhn/install_db.log<o:p></o:p>error reading information on service postgresql: No such file or directory<o:p></o:p>[root ~]# grep "error reading information" `which spacewalk-setup`<o:p></o:p>[root ~]# chkconfig --list | grep post<o:p></o:p>postfix 0:off 1:off 2:on 3:on 4:on 5:on 6:off<o:p></o:p>postgresql-9.3 0:off 1:off 2:on 3:on 4:on 5:on 6:off<o:p></o:p>udev-post 0:off 1:on 2:on 3:on 4:on 5:on 6:off<o:p></o:p><o:p> </o:p>It looks like to me that the install script supports postgresql version 8.4 ONLY. Has anyone actually done a straight install (not an upgrade of postgresql ) of spacewalk with postgresql v9.*?<o:p></o:p><o:p> </o:p>Am I going to have to do what Jonathan says to install the 8.4 postgresql package(s) and then hide the binaries? This seems really ridiculously complicated. It can’t possibly be that involved to change the perl code that’s looking for the postgres components to have it check for the right names for a higher version. It would be fairly easy to set up a table to have it check for any version of postgresql, extract the version number and select where to find the files necessary based on the version. <o:p></o:p><o:p> </o:p>I’ll be happy to have a go at it if I can figure out where the routines are that handle that. At least perl is in my skillset.<o:p></o:p><o:p> </o:p><div>Robert Boyd<o:p></o:p>Sr. Systems Engineer <o:p></o:p>PeopleFluent<o:p></o:p>p. 919-645-2972 | c. 919-306-4681<o:p></o:p>e. <a href="mailto:robert.boyd@peoplefluent.com">Robert.Boyd@PeopleFluent.com</a><o:p></o:p></div><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><a href="http://www.peoplefluent.com/"><img border=0 width=150 height=62 id="_x0000_i1027" src="cid:image001.png@01CFABFD.EB8EE5C0" alt="http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png"></a><o:p></o:p></td></tr></table><o:p> </o:p><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'> Visit: <a href="http://www.peoplefluent.com/">www.peoplefluent.com</a> | Read: <a href="http://peoplefluent.com/resources/peoplefluent-blog">Peoplefluent Blog</a> | Follow: <a href="http://twitter.com/peoplefluent">@peoplefluent</a> | Download: <a href="http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8">iPad App</a><o:p></o:p></td></tr></table><o:p> </o:p><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Jonathan Hoser Sent: Thursday, July 24, 2014 11:00 AM To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Support for postgresql > 8.4<o:p></o:p></div></div><o:p> </o:p><div>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:<o:p></o:p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div>Bedankt for the suggestion Andreas,<o:p></o:p> <o:p></o:p>It appears that someone previously – in 2012 logged a report about this very same problem with the installation procedure.<o:p></o:p> <o:p></o:p>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. <o:p></o:p> <o:p></o:p>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.<o:p></o:p> <o:p></o:p>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. <o:p></o:p> <o:p></o:p><div>Robert Boyd<o:p></o:p>Sr. Systems Engineer <o:p></o:p>PeopleFluent<o:p></o:p>p. 919-645-2972 | c. 919-306-4681<o:p></o:p>e. <a href="mailto:robert.boyd@peoplefluent.com">Robert.Boyd@PeopleFluent.com</a><o:p></o:p></div><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><a href="http://www.peoplefluent.com/"><img border=0 width=150 height=62 id="Picture_x0020_1" src="cid:image001.png@01CFABFD.EB8EE5C0" alt="http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png"></a><o:p></o:p></td></tr></table> <o:p></o:p><table class=MsoNormalTable border=0 cellpadding=0><tr><td style='padding:.75pt .75pt .75pt .75pt'> Visit: <a href="http://www.peoplefluent.com/">www.peoplefluent.com</a> | Read: <a href="http://peoplefluent.com/resources/peoplefluent-blog">Peoplefluent Blog</a> | Follow: <a href="http://twitter.com/peoplefluent">@peoplefluent</a> | Download: <a href="http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8">iPad App</a><o:p></o:p></td></tr></table> <o:p></o:p> <o:p></o:p><div><div>From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a 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 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 ?<o:p></o:p></div></div> <o:p></o:p>Hi, <o:p></o:p><div> <o:p></o:p></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.<o:p></o:p></div><div> <o:p></o:p><div><div><div><div>Met vriendelijke groet, Andreas Dijkman Oracle Technical Consultant Phone: +31(0)50-210 0132 | Mobile: +31(0)6-8115 2982<o:p></o:p></div><div><a href="http://www.cygnis.nl/">Cygnis</a> | Stationsweg 3B | 9726 AC Groningen<o:p></o:p></div><div>Op maandag afwezig<o:p></o:p></div></div></div></div> <o:p></o:p><div><div>On 23 Jul, 2014, at 23:42 , Boyd, Robert <<a href="mailto:Robert.Boyd@peoplefluent.com">Robert.Boyd@peoplefluent.com</a>> wrote:<o:p></o:p></div><o:p> </o:p>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 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 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 href="mailto:Robert.Boyd@PeopleFluent.com">Robert.Boyd@PeopleFluent.com</a> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></div> <o:p></o:p></div></div></blockquote><o:p> </o:p><pre>-- <o:p></o:p></pre><pre>Jonathan Hoser, M.Sc.<o:p></o:p></pre><pre>Institute of Bioinformatics and System Biology<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>WWW: <a href="http://mips.helmholtz-muenchen.de">http://mips.helmholtz-muenchen.de</a><o:p></o:p></pre><pre><o:p> </o:p></pre><o:p> </o:p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div>Helmholtz Zentrum München Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH) Ingolstädter Landstr. 1 85764 Neuherberg <a href="http://www.helmholtz-muenchen.de">www.helmholtz-muenchen.de</a> 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<o:p></o:p></div></body></html>