For Programmers: Free Programming Magazines  


Home > Archive > PHP Language > October 2006 > PHP 5 & Postgres on Windows









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author PHP 5 & Postgres on Windows
Bruce Greef

2006-10-21, 6:57 pm

I am trying something new - and failing so far.

I can get PHP and MySQL working on apache 2 on an XP machine.

Try postgres - using phpPgAdmin as the initial application - not trying to test
with my own code.

I get an error -

Your PHP installation does not support PostgreSQL. You need to recompile PHP
using the --with-pgsql configure option.

Now I installed the latest windows "complete" version of PHP, and uncommented
the pgsql.dll line in the config. No joy.

Any ideas where I am going wrong?
petersprc@gmail.com

2006-10-21, 6:57 pm

Does phpinfo() list the module? Assume Apache's been restarted and the
..ini changes were made to the .ini file listed in phpinfo....

Bruce Greef wrote:
> I am trying something new - and failing so far.
>
> I can get PHP and MySQL working on apache 2 on an XP machine.
>
> Try postgres - using phpPgAdmin as the initial application - not trying to test
> with my own code.
>
> I get an error -
>
> Your PHP installation does not support PostgreSQL. You need to recompile PHP
> using the --with-pgsql configure option.
>
> Now I installed the latest windows "complete" version of PHP, and uncommented
> the pgsql.dll line in the config. No joy.
>
> Any ideas where I am going wrong?


Bruce Greef

2006-10-22, 3:57 am

petersprc@gmail.com wrote:
> Does phpinfo() list the module? Assume Apache's been restarted and the
> .ini changes were made to the .ini file listed in phpinfo....

No - Yes and yes.

Although the pgsql.dll file is included in the package in the \ext directory,
mysql loads its dll in the PHP root directory. Moving that to the ./ext
directory breaks MySQL but Postgres appears in the phpinfo() modules.

Solution is a kludge at present - If I move the pgsql.dll file to the php root,
and leave the php.ini directive as -- extension_dir = "./".

Both work with this configuration...

Thanks for the help.

>
> Bruce Greef wrote:
>
>
>

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2009 codecomments.com