• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4613
  • Last Modified:

Fatal error: Call to undefined function pg_connect()

Hi,
I wonder if you could please help.
I installed Debian 5 and setup postgresql and its working fine. But PHP is not working fine.
It does not recognise posgresql functions. Fatal error: Call to undefined function pg_connect()
I looked in etc/php5/config.d/php.ini and even added a line extention extension=pgsql.so and restarted. No difference. I also tryed phpinfo() and it displayed info apart from any thing with postgresql or pg. I tryed to down load php-pgsql but its already a package of debian 5. I am new to this and if you could please explain step by step that would be so nice.
Kind regards
Me
0
RaviOptics
Asked:
RaviOptics
1 Solution
 
webwyzsystemsCommented:
As well as uncommenting the line in php.ini  you also need to copy php_pgsql.dll to somewhere in the PATH (example:  c:\winnt\system32). The php_pgsql.dll DLL should be in your PHP installation somewhere, you'll have to search for it.

You shouldn't ever need to ADD anything to the php.ini file. It has everything generally needed. You only need to uncomment the appropriate lines.
0
 
karlwilburCommented:
You will not need to worry about DLL files since you are not running on Windows. Debian's aptitude (or apt-get) should configure everything exactly as you need it.

If you had to add "extension=pgsql.so" then it was not installed correctly. Are you trying to use PHP as CGI, CLI or an Apache module?

Assuming Apache module, you should see a file "/etc/php5/apache2/conf.d/pgsql.ini" This file would contain the "extension" directive. (this is Debian and Ubuntu specific...not to be assumed for other Linux flavors, MasOS or Windows)

If that file is missing, try this and tell me what you get:

sudo aptitude install php5-pgsql

Open in new window

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now