On Wed, 2006-03-29 at 16:48, Antimon wrote:
> Yes i tried and realized apache child processes..
> Then i looked for another pooling solution, the project pgpool i found.
> No windows binaries, it might run on cygwin.
> After all, i think postgreSQL is not meant to run on windows production
> for ~2 more major releases or something. It performs great on linux
> thats for sure but i cannot do the platform decision everytime, so
> gonna stick with mySQL on windows and postgre on linux when i can.
There's a windows version of lighttpd available. That might well do the
trick.
I'd still run ANY database on linux / unix before windows, just cause I
don't trust windows when things go wrong to work right. But there's
certainly nothing stopping you from running a linux or BSD based
postgresql server behind a windows lighttpd.
If the db and web server HAVE to both be on the same server, and you
have to have windows, then you might want to look at firebird, which
apparently has quite good windows performance, and, unlike MySQL has
good SQL compliance and behaviour.