[Spacewalk-list] spacewalk-postgresql-1.8.6-1.el5.noarch.rpm requires postgresql84-contrib

[Jeremy Davis]

Hello Jan and All,

Sorry I should have given a little background. I converted my Spacewalk
Oracle 11G(External DB) solution to Spacewalk PostgreSQL 9.1(External DB)
using Spacewalk 1.6 a while back. Now that 1.8 is released I am cleaning
things up a little bit as in order to get 1.6 working with postgresql 9.1 I
had to use the 84 packages and not 9.1 on the app server. Now that I am
cleaning up the packages I would like to use the 9.1 packages as I feel it
might clear some issues up that I am seeing or maybe improve the situation
a little. (Note: These issues I am talking about seem to be fixed with bug
fixes for 1.8 so I don't think these are 9.1 specific issues just would
like to rule out any incompatibility issues by using the 9.1 packages with
a 9.1 DB instead of 8.4 packages.)

Based on the Spacewalk wiki documentation it states the following "please
make sure the postgresql-contrib >= 8.4 (or postgresql84-contrib on RHEL 5"
) is installed on the PostgreSQL server." and "PostgreSQL 8.4+ as a
database backend." Which leads me to think that I could use a version
higher than 8.4. I also obtained a couple of fixes for escape issues that I
was having with 9.1. Seeing as how I was obtaining support for 9.1 in the
way of bugs being fixed I assumed it would be ok to use 9.1.

What I am really asking is if we can update the rpm require lines to
reflect postgresql-contrib instead of postgresql84-contrib and use the
postgresql >= 8.4 as the means to make sure we get at least 8.4 when
installed via yum. This also seems a lot cleaner than requiring
postgresql84-contrib when that package provides postgresql-contrib in the
package. So it would be really easy to change that to require just
postgresql-contrib instead of postgresql84-contrib. This would allow users
to choose which version of PostgreSQL to use, help smash any bugs that are
found with different versions, and allow Spacewalk to support newer version
more quickly.

If I can't use 9.1 than I would recommend that you update the wiki or allow
me to update the wiki to change the documentation to state that only 8.4 is
a solid requirement and that you can't use a newer version.

Thank you for your time and have a great day!

Regards,
Jeremy

On Tue, Nov 20, 2012 at 10:52 AM, Jan Pazdziora <jpazdziora at redhat.com>wrote:

> On Tue, Nov 20, 2012 at 10:27:16AM -0700, Jeremy Davis wrote:
> >
> > I am trying to upgrade to Spacewalk 1.8 and hit a dependency issue with
> > spacewalk-postgresql package.  It is requiring postgresql84-contrib when
> I
> > would like to use the postgresql91-contrib.
>
> I really recommend separating the task of upgrading Spacewalk from the
> task of attempting to use different version of PostgreSQL than shipped
> with your version of RHEL/OS. With the later is introduce yet another
> layer of potential incompatibility to your setup.
>
> > Is there anyway that I can use
> > the 91 package instead of the 84 package? If I can't use the 9.1 package
> > would using the 84 packages with a 9.1 database going to cause any
> issues?
>
> The contrib package has to match the PostgreSQL server version,
> really. Is the database server on the same machine as the Spacewalk
> installation, or is that an external database?
>
> --
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
>
> _______________________________________________
> 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/20121120/3f1c4702/attachment.htm>