Connection Error

Hi,

I am trying to develop a graphical and statistical interface wiht PHP and
Postgresql, however it seems is not possible to connect properly to the
database i have creates. Everytime i try to connect to my database i receive
the following message at the PHP interface:

Fatal error: Call to undefined function pg_connect() in
c:\Inetpub\wwwroot\Untitled.php on line 8

I installed php-5.0.5-Win32.zip and PostgreSQL8.0, them both are installed
in my PC (win2000) wich have been configured as a server. What the problem
could be?

Thanks for your answers
Juan



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Connection Error

On Sep 12, 2005, at 9:02 AM, JUAN ERNESTO FLORES BELTRAN wrote:

> I am trying to develop a graphical and statistical interface wiht
> PHP and Postgresql, however it seems is not possible to connect
> properly to the database i have creates. Everytime i try to connect
> to my database i receive the following message at the PHP interface:
>
> Fatal error: Call to undefined function pg_connect() in c:\Inetpub
> \wwwroot\Untitled.php on line 8
>
> I installed php-5.0.5-Win32.zip and PostgreSQL8.0, them both are
> installed in my PC (win2000) wich have been configured as a server.
> What the problem could be?

Windows comes with lots of modules precompiled but they are not
enabled by default. Look at your php.ini file and make sure the
PostgreSQL module is enabled. You should find the line below; just
remove the leading ";".

;extension=php_pgsql.dll



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Connection Error

JUAN ERNESTO FLORES BELTRAN wrote:

> Hi,
>
> I am trying to develop a graphical and statistical interface wiht PHP
> and Postgresql, however it seems is not possible to connect properly
> to the database i have creates. Everytime i try to connect to my
> database i receive the following message at the PHP interface:
>
> Fatal error: Call to undefined function pg_connect() in
> c:\Inetpub\wwwroot\Untitled.php on line 8

You don't have the pgsql.dll extension enabled in the php.ini.

Sincerely,

Joshua D. Drake


>
> I installed php-5.0.5-Win32.zip and PostgreSQL8.0, them both are
> installed in my PC (win2000) wich have been configured as a server.
> What the problem could be?
>
> Thanks for your answers
> Juan
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly



--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster