Re: Running PostgreSQL on Windows

Hi.
Nice pages on installing PostgreSQL on windows..

Here's an additional tip.
1) Before installing as a service add user "postgres" to your system, the
windows way.
you will use this to run ipc deamon and postmaster under.
ipc-deamon will be set so that it will only accept calls from postgres.
start -> run.. -> lusrmgr.msc, OK (on a non ActiveDir machine that is)
2) This user postgres needs special rights: Log on as a service. do:
start -> run.. -> secpol.msc, OK -> and postgres user to the right.
3) use the tigt-security option and install both services under postgres
account. example:
cygrunsrv.exe --install ipc-daemon --desc "IPC Server for Postmaster
Service" --path /bin/ipc-daemon.exe \
--user postgres --passwd${pgpass} --args --tight-security
cygrunsrv.exe --install postmaster --desc "PostgreSQL Database Management
System Service" \
--path /bin/postmaster --args "-D /data -i" --dep ipc-daemon --termsig
INT --user postgres --passwd ${pgpass}
4) Restrict file permissions on the "data" dir to postgres user.

Joek

--- original message ----
Hi all

Maybe this will help:
http://www.jhauser.com/index.php?src=pgwin32

Regards
Conni