Re: Trying to use PGSql with PHP

Odds are what your problem is mitch-matched support.  the rpm version of php
you are using is probably for postgres 6.5.x.  Between that and version 7,
there was a library upgrade and the rpm dependencies are out of wack (rpms
tend not to be very "forward compatable" in many instances that I've
encountered).

In a nutshell, I had the same problem... What did I do?  I un rpm'd Apache,
PHP, and postgres.  I had to recompile them from their source so they find
all the updated libraruies you are using.  Unfortunately, that sucks.
Compiling Apache and PHP is a bit tricky because you have to compile
Apache... then compile php ... then go back and compile part of apache
again... etc.  Compiling the postgres isn't that bad... only have issues
with the man pages... never got that to work past the "make".

php.net has pretty decent documentation on how to compile php and apache
though.


Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "John Tsombakos" <johnts@ziplink.net>
To: <pgsql-general@postgresql.org>
Sent: Sunday, October 08, 2000 1:20 AM
Subject: [GENERAL] Trying to use PGSql with PHP


> I'm trying to setup PostgreSQL on Redhat Linux 6.2 and access it with PHP.
I
> have Apache installed and working, PHP installed and working, and
PostgreSQL
> installed and working. However, I'm trying to get PHP to talk to the
> PostgreSQL system. I believe I need to install php-pgsql-3.0.15-2.rpm, but
> when I try, I get an error saying the that package depends on
> 'libpq.so.2.0'. I have PostgreSQL v7.0.2 (all of the RPMS's) and PHP
3.0.15
> installed.
>
> What am I missing? I'm a bit of a newbie with Linux, so any help will be
> grateful!
>
> Thanks,
> --------------------------------
> John Tsombakos
> johnts@ziplink.net <*>