Hi,

I have created a new patch for compiling PostgreSQL on Windows.

It requires:
- Cygwin B20.1
- a crypt library
- the cygipc package
- added the included headers (endian.h into Cygwin's include/, tcp.h into
include/netinet and un.h into include/sys)

New features:
- it creates only postgres.exe (a hybrid between .EXE and .DLL) - it is
similar to executables on Unix created with gcc -export-dynamic
- it should be possible to run it on non-binary mounts (thanks to Craig
Setera)

Bugs:
- dynamic loading still doesn't work (but it is possible to create the
modules, e.g. plpgsql.dll)
- sometimes the backend survives only one connection from a client, it
crashes before the second connection is established. I have had not time to
investigate this yet.

The binaries are also available, but they are a bit huge (~3 MB in *.tgz)
because it is compiled with debug info.

I think it should be possible to begin incorporating the patches to the main
sources. Some of the changes are new files. And the rest is ifdef-ed (or
ifeq-ed in Makefiles), so it should not interfere with other ports, I hope
:-)

			Dan
Fri, 8 Jan 1999 14:26:54 +0100 
Horak Daniel <horak@mmp.plzen-city.cz>
New patches for running PostgreSQL on Windows
[Charset iso-8859-2 unsupported, filtering to ASCII...]
> Hi,
> 
> I have created a new patch for compiling PostgreSQL on Windows.
> 
> It requires:
> - Cygwin B20.1
> - a crypt library
> - the cygipc package
> - added the included headers (endian.h into Cygwin's include/, tcp.h into
> include/netinet and un.h into include/sys)
> 
> New features:
> - it creates only postgres.exe (a hybrid between .EXE and .DLL) - it is
> similar to executables on Unix created with gcc -export-dynamic
> - it should be possible to run it on non-binary mounts (thanks to Craig
> Setera)
> 
> Bugs:
> - dynamic loading still doesn't work (but it is possible to create the
> modules, e.g. plpgsql.dll)
> - sometimes the backend survives only one connection from a client, it
> crashes before the second connection is established. I have had not time to
> investigate this yet.
> 
> The binaries are also available, but they are a bit huge (~3 MB in *.tgz)
> because it is compiled with debug info.
> 
> I think it should be possible to begin incorporating the patches to the main
> sources. Some of the changes are new files. And the rest is ifdef-ed (or
> ifeq-ed in Makefiles), so it should not interfere with other ports, I hope
> :-)
> 
> 			Dan
> 
> 

I think it is good to merge this into the tree.  Tracking our tree
yourself is very difficult.

Applied.  The only problem is that this part of the patch did not apply
because the function has changed.  In fact, there is no call fdopen()
left in the entire code tree.

Developers, be warned that all open()'s need a win32 test for 'binary'
opening, and Makefiles not need a $(X) optional extension added.

---------------------------------------------------------------------------

***************
*** 88,93 ****
  void
  pq_init(int fd)
  {
  	Pfin = fdopen(fd, "r");
  	Pfout = fdopen(dup(fd), "w");
  	if (!Pfin || !Pfout)
--- 88,102 ----
  void
  pq_init(int fd)
  {
+ #ifdef __CYGWIN32__
+ 	/*  the fd file handle isn't readable :)
+ 	    it can probably be an error in Cygwin B19.3 */
+ 	int flags, res;
+ 	
+ 	flags = O_RDWR;
+ 	res = fcntl(fd, F_SETFL, flags);
+ #endif
+ 	
  	Pfin = fdopen(fd, "r");
  	Pfout = fdopen(dup(fd), "w");
  	if (!Pfin || !Pfout)


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sun, 17 Jan 1999 01:16:58 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] New patches for running PostgreSQL on Windows
[Charset iso-8859-2 unsupported, filtering to ASCII...]
> Hi,
> 
> I have created a new patch for compiling PostgreSQL on Windows.
> 
> It requires:
> - Cygwin B20.1
> - a crypt library
> - the cygipc package
> - added the included headers (endian.h into Cygwin's include/, tcp.h into
> include/netinet and un.h into include/sys)

I have created an include/win32 directory, and put these files in there
with a README.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sun, 17 Jan 1999 01:26:52 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] New patches for running PostgreSQL on Windows