How to get PostgreSQL support w/PHP

pablogosse

Hi all. I've been given a laptop with RedHat 8.0 and PHP installed, but I need to get PostgreSQL support going, other than what is provided with dbx (I'm using ADOdb).

Do I need to recompile PHP (it, Apache and PostgreSQL were all installed straight from the RedHat cd) in order to get PostgreSQL support?

Thanks in advance,
Pablo

shu

You need to have the php rpm installed as well as a php-pgsql-*.i386.rpm package to enable postgres support in php! Good luck...

pablogosse

Well, I managed to get postgresq support (uncommented pgsql.so and made sure I had the pgsql.so file present), but now I can't get it to connect. Grrrr......

shu

Originally posted by pablogosse
Well, I managed to get postgresq support (uncommented pgsql.so and made sure I had the pgsql.so file present), but now I can't get it to connect. Grrrr......

Did it give you any error message? What user are you connecting to the database?

pablogosse

Okay, after much frustration, cursing, smoking, and being brought almost to the point of beating the laptop to a pulp, everything works.

What needed to be changed was the following.

php.ini need to be chowned to the user nobody
need to install the pgsql.so file and uncomment that line in php.ini
needed to set tcpip_socket to true in postgreSQL.conf
needed to add an entry for 127.0.0.1 in pg_hba.conf

and then everything works........