Re: Question about cygwin/Postgre - Mailing list pgsql-novice

From Phillip J. Allen
Subject Re: Question about cygwin/Postgre
Date
Msg-id 3D91D60E.8070906@attglobal.net
Whole thread Raw
In response to install problem  (sol <sol@autonomon.net>)
Responses Re: Question about cygwin/Postgre
List pgsql-novice
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.
>
>
>




pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: install problem
Next
From: "Patrick Hatcher"
Date:
Subject: Cleaning text with function?