Re: Postgres from PHP in Leopard

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 do a fair bit of PHP+PG on my Mac too.

> I have managed to install Postgres from http://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.

Hmm - never come across that sourceforge project. I installed the
development kit from Apple and compile from source. It's not terribly
difficult.

> 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.

There's some older info here:
http://www.entropy.ch/software/macosx/postgresql/
http://developer.apple.com/internet/opensource/postgres.html

But I think you want this:
http://www.finkproject.org/

Access to all sorts of stuff, including alternative versions of apache,
php etc. Read the documentation *before* you start though so you
understand what it's doing.

--
Richard Huxton
Archonet Ltd