Re: DBD-Pg Install problems

No where in the postgres documentation was I told to set POSTGRES_HOME.  I can connect
to the database from the command line and do everything I need so I assume that
postgreSQL is setup properly.  I am told that DBD installs just fine when postgreSQL is
installed in the default location on RedHat.  I am using Mandrake which should be based
on RedHat.  I am not sure if the Mandrake folks moved postgreSQL files around or not.
confirm?

I checked the documentation and still not sure what I should set POSTGRES_HOME to.
I set it to /usr/lib/pgsql where some files are found and /var/lib/pgsql where other
postgres files are found and tried to install DBD but it still told me that I needed to
set POSTGRES_HOME.  What is DBD looking for anyway?

can anyone shed light on how to get DBD installed on Linux Mandrake 6.0 running
PostgreSQL 6.4.2?  I would prefer RPMS but that is not an option because of the great
RPM consipiracy in that you can never find the latest and greatest of anything in rpm
format until 6months to 1 year after the .tar.gz. (yes even on rpmfind.net or google
search I cannot find the latest DBI/DBD)

thanks for your help

Astro (frustrated)
(Please CC: me if you post to mailing list)


Dana Hudes wrote:

> You have to set up PostgreSQL properly in order to build DBD:Pg.
>
> On Sun, 1 Aug 1999, astromonk wrote:
>
> > ok so I gave in for a moment and tried to install non RPMS version of DBD and
> > running perl Makefile.PL I get a message that I need to set POSTGRES_HOME?  What
> > should this be set to?  I have files in /usr/lib/pgsql and /var/lib/pgsql.
> >
> > thanks
> >
> > astro
> >
> > Dana Hudes wrote:
> >
> > > Don't use rpm for perl stuff. Don't use the RedHat Perl. Its no big deal
> > > to build Perl from stable.tar.gz . PostgreSQL is a bit harder to build.
> > > Once you have built the stable version of Perl and installed it, use CPAN
> > > to get your Perl stuff.
> > > You probably have to just delete /usr/bin/perl and all the perl stuff you
> > > have, rather than rpm -e , so you have rpm entries for Perl if anything
> > > wants it.
> > >
> > > On Sat, 31 Jul 1999, astromonk wrote:
> > >
> > > >     *** From dbi-users -- To unsubscribe, see the end of this message. ***
> > > >
> > > > Hello:
> > > >
> > > > I am trying to install DBI/DBD for postgreSQL. I found
> > > > perl-DBI-1.06-1.i386.rpm on rpmfind.net and it installed just fine but
> > > > when I tried to install perl-DBD-Pg-0.91-1.i386.rpm I get a message that
> > > >
> > > > this package needs libpq.so.1.  What package do I need to install to
> > > > find libpq.so.1?
> > > >
> > > > I have the following currently installed:
> > > >
> > > > postgresql-clients-6.4.2-8mdk
> > > > postgresql-devel-6.4.2-8mdk
> > > > postgresql-data-6.4.2-4
> > > > postgresql-6.4.2-8mdk
> > > > perl-DBI-1.06-1
> > > > perl-5.00503-3mdk
> > > >
> > > > I want to install:
> > > > perl-DBD-Pg-0.91-1.i386.rpm
> > > >
> > > > thanks
> > > >
> > > > astromonk
> > > > (please CC: me on email if you post to the mailing list)
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------------------------------------------------
> > > > To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
> > > > If you are without web access, or if you are having trouble with the web page,
> > > > please send mail to dbi-users-request@isc.org with the subject line of
> > > > 'unsubscribe'.
> > > > ------------------------------------------------------------------------------
> > > >
> >