I installed postgres on windows7 and tried to start the service through control panel. It produces error 1053.
When I try to run postgres.exe from command line, I get this message:
C:\Program Files (x86)\PostgreSQL\9.0\bin>postgres.exe 2011-07-24 14:02:29 IST LOG: could not create file "postmaster.opts": Permission denied
The default data directory is
C:\Program Files (x86)\PostgreSQL\9.0\data
I have set the PGDATA env variable to the above directory.
Also, I have edited the
pg_hba.conf file in that directory to add a new line as below:
local all postgres ident sameuser
I tried to start the service with postgresql server allowed (both private and public networks ticked) in Windows Firewall, and when that didn't solve the problem, turned off the firewall for both public and private networks..
Still the service cannot be started. I tried disabling the AVG resident shield. None of these worked.
Any idea what to do?
I tried this:
C:\Program Files (x86)\PostgreSQL\9.0\bin>pg_ctl restart pg_ctl: PID file "C:/Program Files (x86)/PostgreSQL/9.0/data/postmaster.pid" does not exist Is server running? starting server anyway server starting C:\Program Files (x86)\PostgreSQL\9.0\bin>2011-07-24 16:12:57 IST LOG: could not create file "postmaster.opts":
Still no luck.
As for the logs, I found 2 txt files in folder
data/pg_log. They contain logs of events immediately after installation, not my later attempts at starting postgres. I have put it here.
In windows event viewer, I get a series of error event entries like http://pastebin.com/K6jUPPAy. All of them contain messages similar to:
2011-07-24 12:46:44 IST FATAL: could not access status of transaction 0 2011-07-24 12:46:44 IST DETAIL: Could not open file "pg_notify/0000": Permission denied.
If there are any other logs, please tell me where I can find them.