Cygwin PostgreSQL seems to work fine

If you've ever tried to install PostgreSQL under Windows, you know,
despite the help offered by several FAQs and on these lists, it can be a
pain.

Mercifully, the latest cygwin downloads include PostgreSQL, and it works
fine, almost out of the box.

1) Install cygwin from www.cygwin.com.
2) Donwload the binary cygipc distribtuion from
   http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/

   (Tested w/cygipc 1.09-2)
3) Move the cygipc tarball to the root of your cygwin installation
   (by default, c:\cygwin)
4) In cygwin, unpack this with:
   tar xzvf /cygipc-1.09-2.tar.gz
5) Start cygipc running with /usr/local/bin/ipc-daemon &
6) initdb -D /var/pgsql
7) pg_ctl -D /var/pgsql
8) psql template1

Worked fine for me, and much easier than the tangle of things to try
when working from the source install.

(Tried on Win2000 professional & Win2000 server).


The short story: if you've tried before and given up, try now.

HTH,

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington