Thread: Re: DBD-Pg Install problems

Re: DBD-Pg Install problems

From
astromonk
Date:
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'.
> > > > ------------------------------------------------------------------------------
> > > >
> >


Re: [GENERAL] Re: DBD-Pg Install problems

From
"Oliver Elphick"
Date:
astromonk wrote:
...
  >I checked the documentation and still not sure what I should set POSTGRES_HO
      >ME to.
  >I set it to /usr/lib/pgsql where some files are found and /var/lib/pgsql whe
      >re 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?

It's using it here (Makefile.PL):
my %opts = (
...
    INC          => "-I$ENV{POSTGRES_HOME}/include ...
...
    LIBS         => ["-L$ENV{POSTGRES_HOME}/lib -lpq"],

);

So it wants to find the include files and the libraries.

--
      Vote against SPAM: http://www.politik-digital.de/spam/
                 ========================================
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "And why call ye me, Lord, Lord, and do not the things
      which I say?"                   Luke 6:46



Re: [ADMIN] Re: [GENERAL] Re: DBD-Pg Install problems

From
astromonk
Date:

well let's see rpm -ql postgresql-devel
lists the following directorys as having files

/usr/lib/pgsql
/usr/include/pgsql

so now what do i set POSTGRES_HOME to to get this to work?  It would be nice had
it been /usr/pgsql/include and /usr/pgsql/lib but it is not that way.

so do I have to hack the Makefile? Why is it that PostgreSQL has a different
directory structure for the same version on different distributions?  I just want
to get this thing installed and working.

Oliver Elphick wrote:

> astromonk wrote:
> ....
>   >I checked the documentation and still not sure what I should set POSTGRES_HO
>       >ME to.
>   >I set it to /usr/lib/pgsql where some files are found and /var/lib/pgsql whe
>       >re 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?
>
> It's using it here (Makefile.PL):
> my %opts = (
> ....
>     INC          => "-I$ENV{POSTGRES_HOME}/include ...
> ....
>     LIBS         => ["-L$ENV{POSTGRES_HOME}/lib -lpq"],
>
> );
>
> So it wants to find the include files and the libraries.
>
> --
>       Vote against SPAM: http://www.politik-digital.de/spam/
>                  ========================================
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
>                PGP key from public servers; key ID 32B8FAA1
>                  ========================================
>      "And why call ye me, Lord, Lord, and do not the things
>       which I say?"                   Luke 6:46


Re: [ADMIN] Re: [GENERAL] Re: DBD-Pg Install problems

From
"Oliver Elphick"
Date:
astromonk wrote:
  >
  >
  >well let's see rpm -ql postgresql-devel
  >lists the following directorys as having files
  >
  >/usr/lib/pgsql
  >/usr/include/pgsql
  >
  >so now what do i set POSTGRES_HOME to to get this to work?  It would be nice
      > had
  >it been /usr/pgsql/include and /usr/pgsql/lib but it is not that way.
  >
  >so do I have to hack the Makefile? Why is it that PostgreSQL has a different
  >directory structure for the same version on different distributions?  I just
      > want
  >to get this thing installed and working.

So edit Makefile.PL and use explicit paths instead of $POSTGRES_HOME/...
then recompile DBD

--
      Vote against SPAM: http://www.politik-digital.de/spam/
                 ========================================
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "And why call ye me, Lord, Lord, and do not the things
      which I say?"                   Luke 6:46



Re: [ADMIN] Re: [GENERAL] Re: DBD-Pg Install problems

From
Dana Hudes
Date:
Get the 6.5.1 RPMs and it will set up everything for you.

On Sun, 1 Aug 1999, astromonk wrote:

>     *** From dbi-users -- To unsubscribe, see the end of this message. ***
>
>
>
> well let's see rpm -ql postgresql-devel
> lists the following directorys as having files
>
> /usr/lib/pgsql
> /usr/include/pgsql
>
> so now what do i set POSTGRES_HOME to to get this to work?  It would be nice had
> it been /usr/pgsql/include and /usr/pgsql/lib but it is not that way.
>
> so do I have to hack the Makefile? Why is it that PostgreSQL has a different
> directory structure for the same version on different distributions?  I just want
> to get this thing installed and working.
>
> Oliver Elphick wrote:
>
> > astromonk wrote:
> > ....
> >   >I checked the documentation and still not sure what I should set POSTGRES_HO
> >       >ME to.
> >   >I set it to /usr/lib/pgsql where some files are found and /var/lib/pgsql whe
> >       >re 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?
> >
> > It's using it here (Makefile.PL):
> > my %opts = (
> > ....
> >     INC          => "-I$ENV{POSTGRES_HOME}/include ...
> > ....
> >     LIBS         => ["-L$ENV{POSTGRES_HOME}/lib -lpq"],
> >
> > );
> >
> > So it wants to find the include files and the libraries.
> >
> > --
> >       Vote against SPAM: http://www.politik-digital.de/spam/
> >                  ========================================
> > Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> > Isle of Wight                              http://www.lfix.co.uk/oliver
> >                PGP key from public servers; key ID 32B8FAA1
> >                  ========================================
> >      "And why call ye me, Lord, Lord, and do not the things
> >       which I say?"                   Luke 6:46
>
>
> ------------------------------------------------------------------------------
> 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'.
> ------------------------------------------------------------------------------
>