Unable to run PostgreSQL as Windows service
The command runservice can only be executed by the service manager
in order to fix my localhost windows 7 to start postgres as a servicei used the following command to start the data
pg_ctl -D "C:\Program Files\PostgreSQL\9.1\data" start Then checked the status for errors
pg_ctl -D "C:\Program Files\PostgreSQL\9.1\data" status if you get error 1063 , its more than likely permissions, i executed the following command
cacls "C:\Program Files\PostgreSQL\9.1\data" /E /T /C /G postgres:Fthen reran the start/status, it showed everything fine, but still service manager would not start the service
So, in Services->postgresql->options->logon i set the log on as the Local system account instead of the postgres user, and voila it worked
this happened to me because i set my data directory to be somewhere the postgres windows user account didn't have access to.
I had this problem in Windows after a system crash. Running the first command showed invalid data in C:\Program Files\PostgreSQL\9.1\data\postmaster.pid. Deleting that file did the trick. Reference.