PGSQL Will NOT work

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
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

PGSQL Will NOT work

Post by swraman »

Fatal error: Call to undefined function pg_connect()

i have tried everything for the past 5 hours.

I NEED pgsql and PHP 5.2 for a project.

I used to use apache2triad ut it only has php 5.1.

I set up a new server up I get the same error.

I have the php_pgsql.dll extension line uncommented each time I tried it. Still same error. I restarted Apache each time I made a change.

Any help?

Tanks
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: PGSQL Will NOT work

Post by VladSun »

Sure :)
Add the path to PG SQL client DLLs (e.g. "bin" directory in your PG SQL install directory) to Windows PATH environment variable ;)
Also, it's good for you to have a look at Apache error log files from time to time ;)
There are 10 types of people in this world, those who understand binary and those who don't
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

Re: PGSQL Will NOT work

Post by swraman »

Still a no go. :(

Any other advice? Thanks
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: PGSQL Will NOT work

Post by VladSun »

Could you post the output of

Code: Select all

PATH
run into MS Console?
Did you restart Apache service?
What do you have in your Apache error logs?
There are 10 types of people in this world, those who understand binary and those who don't
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

Re: PGSQL Will NOT work

Post by swraman »

Thanks, I got it :)

I just started over from the eginning and the db connects now :)

ut I have nother question, the script I have isnt working and I want to know if it created the required entries in the db, is there any way to actually view the actual data in the tales of the DB?

in pgAdmin, I can see all the tables and their columns, but it says there are 0 rows...does that mean that there is no data in the tale?

Thanks
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

Re: PGSQL Will NOT work

Post by swraman »

OK I got that sorted out too. Thanks for the help :)
Post Reply