Thread: 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'. > > > > ------------------------------------------------------------------------------ > > > > > >
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
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
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
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'. > ------------------------------------------------------------------------------ >