<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type"
content="text/html; charset=ISO-8859-1">
<title>PostgreSQL Native Win32 Status Report</title>
</head>
<body>
<h1 style="text-align: center;">Compiling PostgreSQL On Native Win32 FAQ<br>
</h1>
<P>Last updated: Thu Oct 14 18:22:57 EDT 2004</P>
<P>Current maintainer: Bruce Momjian (<A href=
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
</P>
<P>The most recent version of this document can be viewed at <A href=
"http://www.postgresql.org/docs/faqs.FAQ_MINGW.html">
http://www.postgresql.org/docs/faqs.FAQ_MINGW.html</A>.</P>
<P>The FAQ for running PostgreSQL on native Win32 is at <A href=
"http://pginstaller.projects.postgresql.org/FAQ_windows.html">
http://pginstaller.projects.postgresql.org/FAQ_windows.html</A>.</P>
<p>The native Win32 port is built from source using MinGW tools.
There is also a precompiled binary installer called <span
style="font-style: italic;">pginstaller</span> which you can download
from <a href="http://pgfoundry.org/projects/pginstaller">http://pgfoundry.org/projects/pginstaller</a>.
It is a fully native build and uses no additional software like MinGW.<br>
</p>
<h2>Tools for Building Binaries<br>
</h2>
<p> The native Win32 port requires a 32-bit NT-based Microsoft
operating
system, like Windows NT 4, Windows 2000/2003, or Windows XP. (NT 4
doesn't support tablespaces because it doesn't support the junction
points needed for symlinks.) Earlier
operating systems do not have sufficient infrastructure. Building the
port also
requires MinGW and Msys, which can be downloaded from <a
href="http://www.mingw.org/">http://www.mingw.org/</a>. MinGW is
a Unix-like build environment for Microsoft operating systems.
Msys is a collection of unix tools required to run shell scripts like <i>configure.
</i>Neither is required to run the resulting binaries; they are
needed only for creating the binaries. We have no intention
of supporting Visual C; their build environment is just too different
from Unix, and maintenance of such a build environment would be too
burdensome.<br>
</p>
<h2>Steps For Building Binaries<br>
</h2>
<ul>
<li>Download the nightly snapshot tarball from <a
href="ftp://ftp.postgresql.org/pub/dev">ftp://ftp.postgresql.org/pub/dev</a>
or checkout via CVS (you will need <i>bison, flex,</i> and <i>perl</i>
installed to build from CVS)<br>
</li>
<li>Run <i>configure</i> (you might need to add the --without-zlib
argument, depending on whether you have installed <span
style="font-style: italic;">zlib
</span>on MinGW)</li>
<li>Run <i>make install</i></li>
</ul>
Note: it is suggested that you run <i>psql</i> under <i>CMD.EXE.</i>,
as the Msys console has buffering issues.<br>
<br>
If you make a change that you want to contribute, make a context diff
and send
it to the mailing list. <br>
<h2>Access</h2>
The mailing list for discussion is
<i>pgsql-hackers-win32@postgresql.org</i>. You can subscribe by sending
an email body containing the word <i>subscribe</i> to <i><a
href="mailto:pgsql-hackers-win32-request@postgresql.org">pgsql-hackers-win32-request@postgresql.org</a></i>.<br>
<h2>Resources</h2>
There are several resources that helped us complete this port:<br>
<ul>
<li>PeerDirect port of PostgreSQL 7.2 to Win32 (<a
href="ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect">ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect</a>)</li>
<li>CONNX Win32 signal code(<a
href="ftp://momjian.postgresql.org/pub/postgresql/win32/CONNX">ftp://momjian.postgresql.org/pub/postgresql/win32/CONNX</a>)</li>
<li>SRA port of PostgreSQL to Win32 (unfortunately, this is not
publically available because the threaded portion is proprietary)</li>
<li>CHM help files (<a
href="http://www.pgadmin.org/snapshots/help/en_US/pgadmin3.chm">http://www.pgadmin.org/snapshots/help/en_US/pgadmin3.chm</a>)</li>
</ul>
</body>
</html>
