Re: PostgreSQL and Cygwin as production database

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: "Steve Slatcher" <steve_slatcher(at)scientia(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: PostgreSQL and Cygwin as production database
Date: 2002-04-16 08:01:10
Message-ID: 200204161001.10444.jm.poure@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

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

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Tim Finch 2002-04-16 09:54:21 Re: PostgreSQL and Cygwin as production database
Previous Message Leandro Guimarães Faria Corsetti Dutra 2002-04-15 16:01:41 Re: PostgreSQL and Cygwin as production database