Thread: Running PostgreSQL on Windows
Hi I am have installed PostgreSQL7.3.1Alpha on my Windows 2000 PC. The problem is that it does not start the server and does not allow to create a Database "createdb". What must I do? Please, help! Mr. Akhona Damane CSIR Environmentek Spatial Technology (012) 841 3188 Fax (012) 8412689 adamane@csir.co.za -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support.
Akhona,
On Mon, Oct 20, 2003 at 10:43:32AM +0200, Akhona Damane wrote:
> I am have installed PostgreSQL7.3.1Alpha on my Windows 2000 PC. The
> problem is that it does not start the server and does not allow to
> create a Database "createdb".
>
> What must I do? Please, help!
Why don't you try the (latest) version which is part of the standard
Cygwin distribution?
http://sources.redhat.com/ml/cygwin-announce/2003-09/msg00036.html
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Hi all Maybe this will help: http://www.jhauser.com/index.php?src=pgwin32 Regards Conni
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