>, if you are working a multi platform enviroment, and you want to run Postgresql on a windows machine, it really cant be done.
>
>
>Why not?
>
>I have the postgres running on RH 7.1 and can access it from windows. Are you saying the reverse is not true? I'm not saying you are wrong - I just don't know.

John, the way you set up PostgreSQL is the only reliable to run it. Here is an old kludge, updated to work on Win2000. Win2000 is the only WinXX I would do this on because it is the most stable of the WInXX platforms. It involves creating a little Linux paradise on a WinXX formatted HD. :)

Install the lastest verion(1.3.2) 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.09-2.tar.gz in"/" directory.
2. tar zxvf cygipc-1.09-2.tar.gz
Install PostgreSQL 7.1.2
1. Download PostgreSQL 7.1.2 sourcecode in /usr/src.
2. tar zxvf postgresql-7.1.2.tar.gz
3. mkdir -p /usr/local/pgsql/{bin,include,lib,data}
4. cd /usr/src/postgresql-7.1.2, then run './configure'
5. make; make install
6. cp/usr/local/pgsql/lib/pq.dll /usr/local/pgsql/bin
7. 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
8. source /.bashrc, then run ``ipc-daemon &''
9. initdb
Note that the owner of the DB system have to be different from root/administrator
10. Editthe file /usr/local/pgsql/data/pg_hba.conf, such as:
host all 163.17.11.109 255.255.255.0 trust

11. postmaster-i&
12. Run 'psql -h host_name template1'. It's easy, huh :-)




Last updated: 05/31/2001 Author: KevinLo