FAQ_MSWIN

*  You can get the most recent version of this from
*  http://people.freebsd.org/~kevlo/postgres/portNT.html.

*  Problem reports can be sent to pgsql-ports@postgresql.org.

How do I install the PostgreSQL server on Windows NT or Windows 2000?
=====================================================================

         Porting PostgreSQL to Windows 2000 installation procedures
                                      
   Thanks to Daniel Horak, JasonTishler ,Joost Kraaijeveld and Pete
   Formanfor their helps.
   Without them, I cannot port Postgres to Windows 2000 successfully.
   ______________________________________________________________________
   
     * 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://www.neuro.gatech.edu/users/cwilson/cygutils/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 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's 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 :-)
   
   
                Last updated: 01/05/2001    Author: KevinLo