Porting PostgreSQL to Windows 2000 installation procedures

Install the lastest verion(1.1.5) of Cygwin
            1. Click on the "Install Cygwin now" link on the http://sources.redhat.com/cygwinwebpage.
                This downloads setup.exe to your system.
            2. Run setup and answer all of the questions. Please choose a mirror sitefor your download.
Install Charles Wilson's Cygwin32 IPC package
            1. Download the precompiled binary http://cygutils.netpedia.net/V1.1/cygipc/cygipc-1.07-1.tar.gzin"/" directory.
            2. tar zxvf cygipc-1.07-1.tar.gz
Install PostgreSQL 7.0.3
            1. Download PostgreSQL 7.0.3 ftp://ftp.postgresql.org/pub/v7.0.3/postgresql-7.0.3.tar.gz sourcecode in /usr/src.
            2. tar zxvf postgresql-7.0.3.tar.gz
            3. mkdir -p /usr/local/pgsql/{bin,include,lib,data}
            4. cd /usr/src/postgresql-7.0.3/src/win32
            5. cp endian.h /usr/include
                cp tcp.h /usr/include/netinet
            6. Apply Jason Tishler'shttp://people.freebsd.org/~kevlo/postgres/patch.diff> patches  in /usr/src/postgresql-7.0.3, then run 'patch -p1 <patch.diff'.
                Note that some browsers convert the patch to a text mode file (i.e., CRNL line endings)
            during the save operation which causes patch    to reject all hunks.
            7. cd /usr/src/postgresql-7.0.3/src, then run './configure'
            8. make; make install
            9. cp/usr/local/pgsql/lib/pq.dll /usr/local/pgsql/bin
          10. Usingany editor to create .bashrc in / directory as belows:
                  PATH=$PATH:/usr/local/pgsql/bin:/usr/local/bin
                  PGDATA=/usr/local/pgsql/data
                  PGLIB=/usr/local/pgsql/lib
                  LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/local/lib
                  export LD_LIBRARY_PATH PATH PGDATA PGLIB
          11. source/.bashrc, then run 'initdb'
                Note that the owner of the DB system have to be different from root/administrator
          12. Editthe file /usr/local/pgsql/data/pg_hba.conf, such as:
                host        all    163.17.11.109  255.255.255.0  trust

          13. ipc-daemon&
          14. postmaster-i&
          15. Run' psql -h host_name template1'. It's easy, huh :-)