Thread: PostgreSQL and Cygwin stability as a production db

Hello,
        I run a ~30 users db on PostgreSQL+Cygwin+NT4 on a proliant. The only real problem I have had is that the postmaster doesn't always seem to have enough time to terminate its children during reboot, so you can end up leaving the postmaster.pid file. The major limitations are a 63 Process fork limit and the fact cygwin's fork actually copies memory (plus fiddles some file descriptors) makes connections slower.

hth,
- Stuart

-----Original Message-----
From: Alan Caudill [mailto:acaudill@centerrun.com]

Does anyone have experience running PostgreSQL on Cygwin in a production environment they can share?
 
I have an existing application that uses an embedded PostgreSQL db and want to do a Windows (Win2k) version.  I'm less concerned with install issues, but would like to know about stability and performance.  I'm especially concerned with stability over the long term.

 
Thanks.
 
            -Alan

Sorry to reply to myself, but I just thought to mention that I used rename rather than the link option in xlog.c.
- Stuart

-----Original Message-----
From: Henshall, Stuart - WCP [mailto:SHenshall@westcountrypublications.co.uk]
Sent: 06 June 2002 10:35
To: 'Alan Caudill'; 'pgsql-cygwin@postgresql.org'
Subject: Re: [CYGWIN] PostgreSQL and Cygwin stability as a production db

Hello,
        I run a ~30 users db on PostgreSQL+Cygwin+NT4 on a proliant. The only real problem I have had is that the postmaster doesn't always seem to have enough time to terminate its children during reboot, so you can end up leaving the postmaster.pid file. The major limitations are a 63 Process fork limit and the fact cygwin's fork actually copies memory (plus fiddles some file descriptors) makes connections slower.

hth,
- Stuart
-----Original Message-----
From: Alan Caudill [mailto:acaudill@centerrun.com]
Does anyone have experience running PostgreSQL on Cygwin in a production environment they can share?
 
I have an existing application that uses an embedded PostgreSQL db and want to do a Windows (Win2k) version.  I'm less concerned with install issues, but would like to know about stability and performance.  I'm especially concerned with stability over the long term.

 
Thanks.
 
            -Alan

On Thu, Jun 06, 2002 at 03:33:47PM +0100, Henshall, Stuart - WCP wrote:
> Sorry to reply to myself, but I just thought to mention that I used rename
> rather than the link option in xlog.c.

As soon as Bruce (hopefully) accepts the patch for the above, I will
release a new 7.2.1 to finally put this one to bed.

Jason