[Spacewalk-list] Postgresql 9.2.5

[Brunck, Paul]

It’s the repository pgdg-centos92-9.2-6.noarch installed from http://yum.postgresql.org/repopackages.php which would have me believe that it was set up specifically for CentOS 6.


From: Paul Robert Marino <prmarino1 at gmail.com<mailto:prmarino1 at gmail.com>>
Reply-To: "spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>" <spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>>
Date: Wednesday, November 6, 2013 at 6:20 PM
To: "spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>" <spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>>
Subject: Re: [Spacewalk-list] Postgresql 9.2.5

Ok there are a couple of tricks here
First I need to know where you got the RPMs from because 9.2 is not native to CentOS 6. Be prepared to do a lot of symlinking I have gotten PostgreSQL 9.2 running with spacewalk on a RHEL 6 host but there are a lot of pitfalls. The most vexing of which is the stock JDBC driver causes a compatibility issue so you will want to repoint some symlinks to the right ones. Also the install script has some staticly coded paths to things it expects to find in the default places so again you will need to create some more symlinks for those as well.



-- Sent from my HP Pre3

________________________________
On Nov 6, 2013 20:04, Brunck, Paul <Paul.Brunck at wolterskluwer.com<mailto:Paul.Brunck at wolterskluwer.com>> wrote:

I attempted to install Spacewalk 2.0 on a server using Postgresql 9.2.5.  Everything works in the setup document until I get to the point where I must run:

spacewalk-setup --disconnected --external-db

Which fails with the error:

** Database: Populating database.
*** Progress: #
Could not populate database.

The above error doesn’t really tell me anything.  The only log I can find to tell me anything:

[root at hostname ~]# tail /var/log/rhn/populate_db.log
SELECT 1
psql:/etc/sysconfig/rhn/postgres/deploy.sql:6: /usr/share/pgsql/contrib/dblink.sql: No such file or directory

There is no pgsql directory below /usr/share.  I have the contrib package installed on CentOS 6.4 which is where this file is supposed to come from.  I am using the 9.2 repository from postgresql.org.

Does this mean that Spacewalk is not compatible with postgresql 9.2?  Is it compatible with any version 9?  I can’t find any dblink.sql anywhere.

Paul Brunck


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20131107/67d2a709/attachment.htm>