<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY><FONT face=Arial color=#0000ff></FONT><BR>
<P>Hi<BR><BR>I use the same configuration as you do :)<BR><BR>I don't know if it
could be a great help for you but<BR><BR>1 did you put "C:\Cygwin\bin" at the
beginning of the PATH<BR> of your machine ?<BR><BR>2 what option did you do
with initdb <option> ??? But i didn't succeed in install postgresql as
service<BR><BR>One of ways I did to lunch/stop PostgreSQL in cygwin is
to<BR><BR>open the file c:\cygwin\etc\bash.bashrc and add<BR><BR><STRONG>alias
startpsql='ipc-daemon &'<BR>alias lunchpsql='pg_ctl start -D
/usr/local/data'<BR>alias stoppsql='pg_ctl stop -D /usr/local/data'<BR>alias
etatpsql='ps e | grep postgres'<BR>ipc-daemon &<BR>pg_ctl start -D
/usr/local/data</STRONG></P><STRONG></STRONG>
<P><BR><BR>Since my initization of postgresql was <EM>initdb
-D /usr/local/data </EM> you have to make the good corrections.</P>
<P>It's different manual ways to know how postgresql is (lunched,
stopped...)</P>
<P>If you stopped your terminal cygwin et relunch it this modifications
automatically lunch postgresql</P>
<P>if you want to stop postgresql just type 'stoppsql' in your cygwin
terminal<BR><BR><BR><BR><BR><BR>>I'm trying to install on WindowsXP under
Cygwin, following the "WindowsHowTo," but I'm stuck at the PostgreSQL
configuration >stage (installing as a service).<BR><BR>>I think I got
through the creation of the postgres account and "log on as a service," though
without explicit directions for >how to do this, I'm not at all confident
that I've done it correctly! If I log off XP from my user account (network
account) >and log in as postgres (local machine account) and run initdb, it
creates the expected folders, but fails on executing >/usr/bin/postgres (the
executable is actually /bin/postgres) and then bails out.
Suggestions?<BR><BR>>Meredith L. (Bud) Bliss, Research Analyst<BR>>Oregon
Criminal Justice
Commission<BR>>www.ocjc.state.or.us<BR><BR><BR><BR><BR>_______________________________________________<BR></P></BODY></HTML>