\cat software
You may have some problems initializing postmaster as an NT service. Follow the instruction below carefully (If you're using Windows 9x/Me, you may want to read /usr/share/doc/Cygwin/postgresql-*.README, but I didn't try it myself.):
PASSWORD and DBNAME below can be whatever you want.
chmod 1777 /tmp chmod 755 /usr/sbin /usr/sbin/* chmod 776 /var/log cygserver-config # answer yes net user postgres PASSWORD /add /fullname:postgres /comment:'PostgreSQL user account' /homedir:"$(cygpath -w /home/postgres)" mkpasswd -l -u postgres >> /etc/passwd # on Windows XP Pro cmd /c secpol.msc # on Windows XP Home editrights -u postgres -a SeServiceLogonRight cygrunsrv --install postmaster --path /usr/sbin/postmaster --args "-D /var/postgresql/data -i" --dep cygserver --termsig INT --user postgres --shutdown mkdir -p /home/postgres mkdir -p /var/postgresql/data chown postgres /home/postgres /var/postgresql/data cygrunsrv -S cygserver
initdb -D /var/postgresql/data
cygrunsrv -S postmaster cygrunsrv -Q postmaster # check if it's running psql -U postgres template1 # is it working? type \q to quit createuser -U postgres # add a user. you may want to answer y to both questions createdb DBNAME psql DBNAME # is it working? great!
Any comments are welcome.