Recently, I am facing problem for not able to start the PostgreSQL service under one of my machine :
Windows XP/Professional/Service Pack3
It had been running no problem previously.
I try to run the following command :
D:\Program Files\PostgreSQL\8.4\bin>pg_ctl.exe runservice -N "postgresql-8.4" -D "D:/Program Files/PostgreSQL/8.4/data" -w
pg_ctl: could not start service "postgresql-8.4": error code 1063
I follow the suggestion http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg83261.html, by running LSPFix.exe. Doesn't help either.
I disable all the firewall, run an antivirus to scan for malware... not work still.
Any suggestion on how I can debug this problem?
Thanks and Regards
Yan Cheng CHEOK