if anyone is interested in installing postgresql on
windows using cygwin.this may be of some help.
I've installed it without a proper guide.
so may be it can help the others.
regards:
Install cygwin:
1) Create a new folder, let c:\cygwininstall
2) Within this new folder copy setup.exe( for cygwin )
as well as all the packages Include all the packages
from Latest as well as Postgresql and readline from
Contrib.(or install directly from net,that is a better
option)
( i included all the packages because I don't exactly
k
now the packages required)
3) Run setup.exe
4) Select local package directory as (say
c:\cygwininstall) and install root directory (say
c:\cygwin).
5) After insalling cygwin package successfully, copy
cygipc-1.09-2.tar.tz in cygwin directory.
6) tar zxvf cygipc-1.09-2.tar.gz
7) mkdir -p /usr/local/pgsql/{bin,include,lib,data}
8) cp/usr/local/pgsql/lib/pq.dll /usr/local/pgsql/bin
9) 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
10) run ``ipc-daemon &''
11). initdb
12) Edit the file
/usr/local/pgsql/data/pg_hba.conf,
such as:
host all 163.17.11.109 255.255.255.0 trust
ipc-daemon &
13) postmaster -i -D /usr/local/pgsql/data > logfile
2>&1 &
14) createdb post1
15) psql -h localhost -p 5432 post1
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
