Thread: Postgres 8.0 vs. Postgres 7.4/Cygwin

Postgres 8.0 vs. Postgres 7.4/Cygwin

From
Scott Goldstein
Date:
I'm currently trying to make a decision on whether to use the Cygwin port of Postgres 7.4  or Postgres 8.0 for a windows installation.  Can someone provide some comparison info?  Specifically,
 
1.  Is the Cygwin port viable for an enterprise environment?  Does it perform?  Is it reliable? 
2.  How reliable is the Cygwin port compared to the 8.0 Windows version?  
3.  Has the Cygwin port been used very much in enterprise systems, or is it intended only for development environments?
 
Thanks for the help.
 
Scott

Re: Postgres 8.0 vs. Postgres 7.4/Cygwin

From
Reini Urban
Date:
Scott Goldstein schrieb:
> I'm currently trying to make a decision on whether to use the Cygwin
> port of Postgres 7.4  or Postgres 8.0 for a windows installation.  Can
> someone provide some comparison info?  Specifically,
>
> 1.  Is the Cygwin port viable for an enterprise environment?

no, certainly not. try the native windows port instead.

> Does it perform?  Is it reliable?

On about 10% percent of the cygwin 8.0 users it has yet unsolved IPC
problems on initial startup.
Loading the perl interpreter (plperl) has also caused IPC problems. (7.4
and 8.0)

> 2.  How reliable is the Cygwin port compared to the 8.0 Windows version?
> 3.  Has the Cygwin port been used very much in enterprise systems, or is
> it intended only for development environments?

yes, the latter.

--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/