Re: PostgreSQl, PHP and IIS

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Mark Williams <markwillimas(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, daniel(at)manitou-mail(dot)org
Subject: Re: PostgreSQl, PHP and IIS
Date: 2018-09-23 14:35:39
Message-ID: 5b9f5127-989e-5b25-497b-c8922ec29e73@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/23/18 3:54 AM, Mark Williams wrote:
> Thanks for the suggestions.
>
> I don't think there is any dependencies in the lib folder, but added it anyway and it made no difference.
>
> I tried "Process Explorer" (having previously tried "Dependency Walker") PE revealed one or two more dependencies I was previously unaware of. Added these to the root PHP folder, but still got me no further. I have even added Postgres.EXE to the php root folder.
>
> In desperation I tried adding all the postgres files to the PHP Ext folder. Unsurprisingly that did not yield results either.
>
> Does anyone know of a step by step guide for installing php and postgres on windows server? So I can doublecheck to see if there is anything I have missed. I can only assume I have made some simple mistake as it surely can't be this difficult to set up.

Maybe this?:

https://docs.microsoft.com/en-us/iis/application-frameworks/install-and-configure-php-on-iis/install-and-configure-php

>
> Cheers,
>
> Mark
>
> __
>
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: 22 September 2018 16:45
> To: Mark Williams <markwillimas(at)gmail(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org
> Subject: Re: PostgreSQl, PHP and IIS
>
> On 9/22/18 3:06 AM, Mark Williams wrote:
>> "Fatal error: Call to undefined function pg_connect".
>>
>> Obviously, that is to be expected if pgsql module is not loading.
>
> Went back over your previous post and saw:
>
> "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.
> "
>
> I would say add the lib/ of the Postgres install to the search path.
>
>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arup Rakshit 2018-09-23 20:21:19 Help to understand Actual Rows vs Plan Rows from the query planner output
Previous Message Chris Travers 2018-09-23 13:26:15 Re: How to investigate what postgres is spending time on