Re: Postgres from PHP in Leopard

brian wrote:
> 
> 
> Steve Atkins wrote:
>>
>> On Dec 20, 2007, at 7:35 AM, Gordon wrote:
>>
>>> On Dec 19, 11:32 am, Gordon  wrote:
>>>
>>>> I'm a web developer who does a lot of work in PHP.  The back end
>>>> database we use is bases on Postgres.  I am trying to set my new
>>>> MacBook Pro up as a development system.
>>>>
>>>> I have managed to install Postgres 
>>>> fromhttp://sourceforge.net/projects/pgsqlformac/
>>>> and can access the database on my mac with tools such as pgAdmin.  I
>>>> have also enabled the bundled Apache and PHP extensions.
>>>>
>>>> However, the problem is that I can't get PHP to talk to Postgres.
>>>> Running phpinfo () on the built in PHP shows that database support
>>>> extends as MySql, Mysqli and SQLite extensions, and SQLite drivers  for
>>>> PDO.  What I really need is a Postgres extension for maintaining  older
>>>> code and a Postgres PDO driver for new code in development.
>>>
>>
>> It sounds like a PHP problem, not a Postgresql problem. You're
>> more likely to get help with it if you ask on a PHP mailing list, I
>> suspect.
> 
> It's a bit of both, really. You might need to re-compile PHP to make it 
> aware of PG. Did you install it through Fink?

That would be Apple - they don't provide postgresql support with the php 
supplied with OSX. Also their updates can often wipe out a custom built 
version of php.

http://developer.apple.com/internet/opensource/postgres.html

Provides steps to add support which should still apply.


Although he isn't mentioning 10.5 support yet
http://www.entropy.ch/software/macosx/php/
has been a good source of pre-built php for osx which also provides a 
larger feature set compiled into php.



-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz