Re: Question about cygwin/Postgre

Nicolas,

I have been using cygwin and Postgresql on my laptop for experimental
purposes when I am not connected to the server (like in an airport
lobby).  And it seems to be working well.  Of course I havent had
multiple connections simultanous.

But one problem/inconvience you will encounter is if the W2000 server
goes to sleep/dorment, the postmaster will not wake up or recover.  So
you have to manually go into the cygwin directory and erase the
postmaster.pid file.  Not a major crisis on my laptop but on a server it
could be very inconvient.

good luck and keep us informed because I am planning on installing
cygwin and postgres on one of my "field servers" where nobody knows how
to maintain a linux server.  And when I say "field servers" I am talking
about a tool shed in the Peruvian Andes.

Cheers

Phillip J. Allen
Consulting Geochemist/Geologist
Lima Peru
e-mail: paallen@attglobal.net


Nicolas Cartron wrote:

>All,
>
>Currently we're using a server that runs freebsd & postgreSQL.
>
>I've got to install a win 2k server, and i'd like to stay with
>postgre rather than install sql server.
>
>I didn't find any postgre win32 version, and am wondering if
>cygwin/postgre on such a server would be good (i mean in terms
>of performance of course).
>
>The server is an athlon 1.4 GHz with 1 Go RAM and 2 x 80 Go maxtor ide,
>so rather powerful.
>
>Thanks in advance.
>
>
>