Re: DBD-Pg Install problems

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:

Show quoted text

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

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:

Show quoted text

*** 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'.
------------------------------------------------------------------------------

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

------------------------------------------------------------------------
------

Show quoted text