2 Compiling PostgreSQL On Native Win32 FAQ
4 Last updated: Thu Oct 14 18:22:57 EDT 2004
6 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
8 The most recent version of this document can be viewed at
9 http://www.postgresql.org/docs/faqs.FAQ_MINGW.html.
11 The FAQ for running PostgreSQL on native Win32 is at
12 http://pginstaller.projects.postgresql.org/FAQ_windows.html.
14 The native Win32 port is built from source using MinGW tools. There
15 is also a precompiled binary installer called pginstaller which you
16 can download from http://pgfoundry.org/projects/pginstaller. It is a
17 fully native build and uses no additional software like MinGW.
19 Tools for Building Binaries
21 The native Win32 port requires a 32-bit NT-based Microsoft operating
22 system, like Windows NT 4, Windows 2000/2003, or Windows XP. (NT 4
23 doesn't support tablespaces because it doesn't support the junction
24 points needed for symlinks.) Earlier operating systems do not have
25 sufficient infrastructure. Building the port also requires MinGW and
26 Msys, which can be downloaded from http://www.mingw.org/. MinGW is a
27 Unix-like build environment for Microsoft operating systems. Msys is a
28 collection of unix tools required to run shell scripts like
29 configure. Neither is required to run the resulting binaries; they
30 are needed only for creating the binaries. We have no intention of
31 supporting Visual C; their build environment is just too different
32 from Unix, and maintenance of such a build environment would be too
35 Steps For Building Binaries
37 * Download the nightly snapshot tarball from
38 ftp://ftp.postgresql.org/pub/dev or checkout via CVS (you will
39 need bison, flex, and perl installed to build from CVS)
40 * Run configure (you might need to add the --without-zlib argument,
41 depending on whether you have installed zlib on MinGW)
44 Note: it is suggested that you run psql under CMD.EXE., as the Msys
45 console has buffering issues.
46 If you make a change that you want to contribute, make a context diff
47 and send it to the mailing list.
51 The mailing list for discussion is pgsql-hackers-win32@postgresql.org.
52 You can subscribe by sending an email body containing the word
53 subscribe to pgsql-hackers-win32-request@postgresql.org.
57 There are several resources that helped us complete this port:
58 * PeerDirect port of PostgreSQL 7.2 to Win32
59 (ftp://momjian.postgresql.org/pub/postgresql/win32/PeerDirect)
61 code(ftp://momjian.postgresql.org/pub/postgresql/win32/CONNX)
62 * SRA port of PostgreSQL to Win32 (unfortunately, this is not
63 publically available because the threaded portion is proprietary)
65 (http://www.pgadmin.org/snapshots/help/en_US/pgadmin3.chm)