Correction, this was all on Windows Server 2003 Web Edition.
I can't believe i have to reboot the whole sever just to restart the
database cluster.
What is it that the installer does differently from initdb alone?
--
"Patriotism is the conviction that your country is superior to all others
because
Correction, it does not work. At least not the way i think it should.
The database does not start when i register the service with pg_ctl.
I can only start the cluster with the postgres2 user. I get the prompt back,
but i can not close the window. The dos command "exit" causes all
interaction with
ok, when i start a new cmd window from runas, and run the pg_ctl command
from there, the process will start.
btw you also have to change the ownership and permissions on the
postgresql.conf, pg_hba.conf and pg_ident.conf files.
C:\Program Files\PostgreSQL\8.3\bin>runas /user:postgres2 "cmd /k"
Wil
Hi,
I have a pgsql 8.3.3 cluster running on windows.
I want to install another cluster, so i use initdb.
Because the postgres user must own the files, i use runas to run initdb as
postgres2 (the correct user here).
I've created a separate folder for the data files of this cluster. The
folder is ow
