1
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
4
<meta http-equiv="content-type"
5
content="text/html; charset=ISO-8859-1">
6
<title>PostgreSQL Native Win32 Status Report</title>
9
<h1 style="text-align: center;">Compiling PostgreSQL On Native Win32 FAQ<br>
11
<P>Last updated: Thu Oct 14 18:22:57 EDT 2004</P>
12
<P>Current maintainer: Bruce Momjian <<A href=
13
"mailto:bruce@momjian.us">bruce@momjian.us</A>><BR>
16
<P>The most recent version of this document can be viewed at <A href=
17
"http://www.postgresql.org/docs/faqs.FAQ_MINGW.html">
18
http://www.postgresql.org/docs/faqs.FAQ_MINGW.html</A>.</P>
20
<P>The FAQ Running & Installing PostgreSQL On Native Windows is at <A href=
21
"http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html">
22
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html</A>.</P>
24
<p>The native Win32 port is built from source using MinGW tools.
25
There is also a precompiled binary installer called <span
26
style="font-style: italic;">pginstaller</span> which you can find at
27
from <a href="http://pgfoundry.org/projects/pginstaller">http://pgfoundry.org/projects/pginstaller</a>.
28
It is a fully native build and uses no additional software like MinGW.
29
The ready-made installer files are available on the main PostgreSQL ftp servers
30
in the binary/win32 directory.
33
<h2>Tools for Building Binaries<br>
35
<p> The native Win32 port requires a 32-bit NT-based Microsoft
37
system, like Windows NT 4, Windows 2000/2003, or Windows XP. (NT 4
38
is no longer supported since version 8.2) Earlier
39
operating systems do not have sufficient infrastructure. Building the
41
requires MinGW and Msys, which can be downloaded from <a
42
href="http://www.mingw.org/">http://www.mingw.org/</a>. MinGW is
43
a Unix-like build environment for Microsoft operating systems.
44
Msys is a collection of unix tools required to run shell scripts like <i>configure.
45
</i>Neither is required to run the resulting binaries; they are
46
needed only for creating the binaries. Work is in progress to support
47
building using Visual C++ in a future version.<br>
49
<h2>Steps For Building Binaries<br>
52
<li>Download the nightly snapshot tarball from <a
53
href="ftp://ftp.postgresql.org/pub/dev">ftp://ftp.postgresql.org/pub/dev</a>
54
or checkout via CVS (you will need <i>bison, flex,</i> and <i>perl</i>
55
installed to build from CVS)<br>
57
<li>Run <i>configure</i> (you might need to add the --without-zlib
58
argument, depending on whether you have installed <span
59
style="font-style: italic;">zlib
61
<li>Run <i>make install</i></li>
63
Note: it is suggested that you run <i>psql</i> under <i>CMD.EXE.</i>,
64
as the Msys console has buffering issues.<br>
66
If you make a change that you want to contribute, make a context diff
68
it to the mailing list. <br>
70
There are several resources that helped us complete this port:<br>
72
<li>PeerDirect port of PostgreSQL 7.2 to Win32 (<a
73
href="ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect">ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect</a>)</li>
74
<li>CONNX Win32 signal code(<a
75
href="ftp://momjian.postgresql.org/pub/postgresql/win32/CONNX">ftp://momjian.postgresql.org/pub/postgresql/win32/CONNX</a>)</li>
76
<li>SRA port of PostgreSQL to Win32 (unfortunately, this is not
77
publically available because the threaded portion is proprietary)</li>
78
<li>CHM help files (<a
79
href="http://www.pgadmin.org/snapshots/help/en_US/pgadmin3.chm">http://www.pgadmin.org/snapshots/help/en_US/pgadmin3.chm</a>)</li>