Unable to start postgres server
This happened after i modified the pg_hba.conf file. It is currently set on trust but the server still asks for a password (even tho when clicking properties the password field is disabled ) . I treied restarting and now the damn thing wont start at all (the server that is; i have no postgres processes now). I also installed postgres 9.0 now and it works . But i would realy like to regain access to the old server. I have also tried a solution involving resetxlog -f but to no avail
Here is what else i tried :
E:\Program Files\PostgreSQL\8.4.8\bin>pg_ctl.exe start -N "postgresql-8.4.8" -D
"E:\Program Files\PostgreSQL\8.4.8\data" -w
waiting for server to start...2011-09-15 08:17:29 EEST LOG: could not create fi
le "postmaster.opts": Permission denied
............................................................could not start serv
er
E:\Program Files\PostgreSQL\8.4.8\bin>pg_ctl.exe runservice -N "postgresql-8.4"
-D "E:\PostgreSQL\8.4.8\data" -w
pg_ctl: could not start service "postgresql-8.4": error code 1063
While reviewing my pg_hba.conf file I noticed that there was an O at the beginning in stead of a #.
I learned two things from this:
- Always check for the most incredibly stupid mistakes first
- Don't throw your TV out the window unless you have money to buy another one