I have created a small patch that makes possible to compile pgsql on newer

bmomjian · bmomjian · commit 5d76ea6dc58f · 1999-10-12T14:55:01.000Z
Cygwin snapshots (tested on 990115 which is recommended to use - it fixes
some errors in B20.1)

And I have another patch for including &lt;sys/ipc.h&gt; before &lt;sys/sem.h&gt; in
backend/storage/lmgr/proc.c - it is required due the design of cygipc
headers

                        Dan
diff --git a/src/backend/storage/lmgr/proc.c b/src/backend/storage/lmgr/proc.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/storage/lmgr/proc.c,v 1.57 1999/05/25 22:42:03 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/storage/lmgr/proc.c,v 1.57.2.1 1999/10/12 14:55:00 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -46,15 +46,15 @@
  *		This is so that we can support more backends. (system-wide semaphore
  *		sets run out pretty fast.)				  -ay 4/95
  *
- * $Header: /cvsroot/pgsql/src/backend/storage/lmgr/proc.c,v 1.57 1999/05/25 22:42:03 momjian Exp $
+ * $Header: /cvsroot/pgsql/src/backend/storage/lmgr/proc.c,v 1.57.2.1 1999/10/12 14:55:00 momjian Exp $
  */
 #include <sys/time.h>
 #include <unistd.h>
 #include <string.h>
 #include <signal.h>
 #include <sys/types.h>
 
-#if defined(solaris_sparc)
+#if defined(solaris_sparc) || defined(__CYGWIN__)
 #include <sys/ipc.h>
 #include <sys/sem.h>
 #endif
diff --git a/src/include/port/win.h b/src/include/port/win.h
@@ -9,3 +9,8 @@ typedef unsigned char slock_t;
 #define tzname _tzname			/* should be in time.h? */
 #define USE_POSIX_TIME
 #define HAVE_INT_TIMEZONE		/* has int _timezone */
+
+#include <cygwin/version.h>
+#if (CYGWIN_VERSION_API_MAJOR >= 0) && (CYGWIN_VERSION_API_MINOR >= 8)
+#define sys_nerr _sys_nerr
+#endif
