How to compile PosttgreSQL on NT

These are the steps I used to compile and run PostgreSQL on Windows NT.
Notice that I have not verfied it after 24-3-99. In the coming week I hope
to update my webpage.

1. Install the Cygwin package
2. Update to EGCS 1.1.2

1. Install the Andy Piper Tools

1. Download the Cygwin32 IPC Package by .
2. Untar the package and follow the readme instructions.
3. I tested 1.03.
4. I used the \cygwin-b20\h-i568-cygwin32\i586-cygwin32\lib and
\cygwin-b20\h-i568-cygwin32\i586-cygwin32\include\sys instead of the
/usr/local/lib and usr/local/include/sys.

1. Download the current snapshot.tar.gz (24-3-98).
2. Untar the package.
3. Copy the files from \pgsql\src\win32 according to the readme file.
3. Edit \pgsql\src\template\cygwin32 if needed (I had to adjust the YFLAGS
path).
4. ./configure
5. make
6. create the directory /usr/local/pgsql manually: the mkdir cannot create a
directory 2 deep.
7. make install
8. cd /usr/lical/pgsql/doc
9. make install
10. Set the environmental data
11. Initdb--username=jkr (do not run this command as administrator)

12. Open a new Cygwin command prompt
13. Start "ipc-deamon&" (background proces)
14. Start "postmaster -i 2>&1 > /tmp/postgres.log &" (background proces)
15. Start "tail -f /tmp/postgres.log" to see the messages

16. cd /usr/src/pgsql/src/test/regress
17. make all runtest

18. triggers aborts dr watson
19. misc after portals aborts dr watson
20. plpgsql aborts dr watson
21. temp results in a deadlock.


Joost Kraaijeveld
Askesis B.V.
Groenewoudseweg 46
6524VB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
email: JKraaijeveld@askesis.nl
web: www.askesis.nl