Just for the record:
You may remember (but it's not bloody likely, is it?) that I
was trying to get postgresql working on my newly upgraded
RedHat 6.1 box, using the perl DBI/DBD interface.
The trouble was that the latest RPM I could find
(via rpmfind, google, etc), was:
perl-DBD-Pg-0.91-1.i386.rpm
And trying to install this just produced the ever popular
error:
error: failed dependencies:
libpq.so.1 is needed by perl-DBD-Pg-0.91-1
To the chase, it turns out that this was not the latest
RPM. There is a perl-DBD-Pg-0.91-2.i386.rpm, which is
shipped by Redhat on their Powertools disk, but not on the
main disk (despite the fact that they include postgresql on
the main disk, which comes with the older Pg.pm perl
interface). Oddly enough, the rpmfind.net indicies did not
include this package, which is something you want to watch
out for when grepping the world for the latest rpms.
As I understand it, what's going on here is that posgresql
switched libraries after version 6.3 (which shipped with
RedHat 5.2), and now you need binaries that were compiled
against libpq.so.2 rather than libpq.so.1. So once again,
you're stuck with that bane of the linux world, trying to
figure out what libraries you've got, and what what
libraries are required by the available RPMs, and trying to
get the two to match up.
If you're looking for this RPM, you can find it somewhere
like this:
ftp://ftp.labs.redhat.com/pub/redhat/powertools/CPAN/CPAN_rev.2/i386/
though there are many mirrors that it would be nicer (easier
on RedHat's poor overworked servers) to consult.
Check
http://www.redhat.com/download/mirror.html
to find a mirror near you.
And if you're interested in the latest postgresql RPMs
(there are already later ones than those shipped on the
RedHat 6.1 disks), you can go to the official source:
ftp://ftp.postgresql.org/pub/RPMS/redhat-6.x
The www.postgresql.org website has got some interesting
stuff up on it by the way, including a draft of a
forthcoming postgresql book, written by Bruce Momijan:
http://www.postgresql.org/docs/awbook.html
(By the way, on this list "Iain Wade" <[EMAIL PROTECTED]>
suggested that I might want to give up on the RPM process
entirely and just do something like this:
perl -MCPAN -e 'install DBD::Pg'
I gave this a shot, but I kept having problems with it.
The one that finally made me give up on it is that it has to
be run as root to install the files, but then the tests
fail, because root doesn't have permission to create and
destroy postgresql databases, and it was taking me too long
to figure out how to change that...)
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
