RE: PostgreSQl, PHP and IIS - Mailing list pgsql-general

From Mark Williams
Subject RE: PostgreSQl, PHP and IIS
Date
Msg-id 001c01d4525b$fc321830$f4964890$@gmail.com
Whole thread Raw
In response to Re: PostgreSQl, PHP and IIS  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: PostgreSQl, PHP and IIS  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
"Fatal error: Call to undefined function pg_connect".

Obviously, that is to be expected if pgsql module is not loading.

__

-----Original Message-----
From: Adrian Klaver <adrian.klaver@aklaver.com> 
Sent: 21 September 2018 23:02
To: Mark Williams <markwillimas@gmail.com>;
pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQl, PHP and IIS

On 9/21/18 10:35 AM, Mark Williams wrote:
> I have PHP v7.2.7 and PostgreSQL v10 with Windows IIS.
> 
> I am trying to get this to work following any advice I have been able 
> to find on the web, but with no success. My configuration so far is as
below.
> 
> PHP.ini extension list includes both php_pdo_pgsql.dll and php_pgsql.dll.
> 
> Both these dlls are located in the correct extensions directory 
> according to phpinfo.
> 
> According to phpinfo the Configuration File Path is "C:\Windows" and 
> the Loaded Configuration File is "C:\Program Files\PHP\v7.2\php.ini". 
> I have the same php.ini file at both locations.
> 
> I have copied the version of libpq.dll from the lib folder of the 
> postgresql installation to the root folder of the PHP installation.
> 
> I have added the bin folder of the postgresql installation to the 
> Windows system search path.
> 
> Phpinfo shows that pdo_pgsql extension is loaded but not pgsql.
> 
> I have also tried copying the dependent dlls (ssleay32.dll, 
> libeay32.dll, libintl-8.dll, libiconv-2.dll) from the postgresql bin 
> folder to the php root folder).
> 
> Phpinfo show php_pdo_pgsql is enabled, but not php_pgsql.dll and an 
> undefined function call error is displayed by php when I try and run 
> any pg php functions.
> 
> Can anyone please shed any light on what more I need to do?

So what is the error you are getting?

Or to put it another way, what is not happening?

> 
> Regards,
> 
> Mark
> 


--
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: heads up on large text fields.
Next
From: Doron Behar
Date:
Subject: postgresql systemd service fails to start only on boot but notmanually