RE: DBD-Pg Install problems - Mailing list pgsql-general

The Makefile.PL file in the postgres distribution (which is what checks for
POSTGRES_HOME) looks for a $POSTGRES_HOME/lib directory which is documented
as the home of postgresql.  The Redhat distribution puts the postgres user
stuff in /var/lib/pgsql so I set POSTGRES_HOME to /var (the other
alternative was /usr).  To make a long story short, I can't say I
understand everything that is done with the POSTGRES_HOME variable, but
setting it to /var works on the Redhat distribution.

Regards,

-mark

Mark Rowe
E-mail:  mkrowe@peak.org
URL:  http://www.peak.org/~mkrowe



On Sunday, August 01, 1999 5:30 AM, astromonk
[SMTP:astromonk@flashmail.com] wrote:
>     *** From dbi-users -- To unsubscribe, see the end of this message.
***
>
> 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'.
> > > > >
------------------------------------------------------------------------
------
> > > > >
> > >
>
>
>
------------------------------------------------------------------------
------
> 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'.
>
------------------------------------------------------------------------
------
>