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://momjian.postgresql.org/main/writings/pgsql/project/win32.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)