Re: PostgreSQL and Cygwin as production database

Le Mardi 9 Avril 2002 09:56, vous avez écrit :
> Thanks for that Tim.  Could I please ask everyone else though if the
> silence means "of course it's fine in a production environment" or "I
> wouldn't dream of even considering it".  If you think it doesn't make for
> an interesting discusion mail me directly.  Many thanks.

Cygwin is a POSIX emulation layer which works perfectly. The only concern
might be speed: because of memory allocation issues, large database
***might*** run twice as fast under Linux as under Cywin.

Anyway, Cygwin + PostgreSQL still remains faster than any open-source
databases available under Windows.

With hardware being cheaper everyday, this kind of question becomes
old-fashion. Users discover PostgreSQL under Cygwin, and one day or another,
invest in a new platform running under Linux. A powerfull Athlon server does
not cost more than 1.000 euros. So why bother with Windows?

Maybe you should have a look at pgAdmin2, PostgreSQL Windows GUI. Personnaly,
I recommand using PostgreSQL servers under Linux and pgAdmin2 under Windows.

pgAdmin2 is based on pgSchema ocx, a database abstraction layer, which can be
used in any Windows project.

Other source of information to dig into the PostgreSQL world:
http://pgadmin.postgresql.org
http://www.postgresql.org/idocs/index.php
http://techdocs.postgresql.org

Cheers,
Jean-Michel POURE