[SOLVED]Your PHP installation does not support PostgreSQL...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dragonreborn
Forum Newbie
Posts: 8
Joined: Mon Mar 22, 2004 11:49 am
Location: Utah
Contact:

[SOLVED]Your PHP installation does not support PostgreSQL...

Post by dragonreborn »

Running Apache on FreeBSD, and I have webmin installed and use that to try to figure most stuff out.

Ok, so I'm brand new to managing servers and I'm having trouble with my php configuration. I thought I had postgresql support installed with my php (I'm even showing the pdsql folders /usr/local/include/php/ext/pgsql with file php_pgsql.h). I installed phppgadmin but get an error similar to the subject line. For those who don't use phppgadmin the error is thrown from a function_exists("pg_connect") check.

My question: How do I check my php configuration to confirm postgresql support and if it's not there how do I put it there?

Thanks in advance for any comments and questions.
Last edited by dragonreborn on Wed Mar 24, 2004 10:09 am, edited 1 time in total.
User avatar
Slippy
Forum Contributor
Posts: 113
Joined: Sat Jul 12, 2003 11:31 pm
Location: Vancouver eh!

Post by Slippy »

Code: Select all

<?php
php_info();
?>
Should tell you what is installed/configured/compiled

If you are having troubles building the configuration, check out http://www.apachetoolbox.com -- although I seem to recall having problems with apachetoolbox and postgres downloading last time...
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Also, you might have it installed ok, but just not loaded, ie check the php.ini file ( the one that phpinfo() says it is using) and add/uncomment extension=pgsql.so ... then restart apache. If that still fails then you may need to actually install pgsql and recompile PHP --with-pgsql
angusfighter
Forum Newbie
Posts: 19
Joined: Sat Jul 09, 2005 8:07 pm

Post by angusfighter »

excuse me
i think i am having a similar problem

i "uncomment" the extension for the pgsql module
but it seems dun work

i would like to ask how to "recompile" the program
to make the altered "php.ini" file works

thx a lot
angusfighter
Forum Newbie
Posts: 19
Joined: Sat Jul 09, 2005 8:07 pm

Post by angusfighter »

finally i worked it out
i put the php.ini in the Apache folder and then it works

... :cry:

stupid me
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Lets not dig up year old threads, shant we?
Post Reply