And the log message (D:\Program Files\PostgreSQL\8.4\data\pg_log) is as follow :
2010-04-21 13:34:58 MYTLOG: database system was interrupted; last known up at 2010-04-08 14:26:26 MYT
2010-04-21 13:34:58 MYTLOG: could not open file "pg_xlog/000000010000000900000041" (log file 9, segment 65): No such
fileor directory
2010-04-21 13:34:58 MYTLOG: invalid primary checkpoint record
2010-04-21 13:34:58 MYTLOG: could not open file "pg_xlog/00000001000000090000003E" (log file 9, segment 62): No such
fileor directory
2010-04-21 13:34:58 MYTLOG: invalid secondary checkpoint record
2010-04-21 13:34:58 MYTPANIC: could not locate a valid checkpoint record
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2010-04-21 13:34:58 MYTLOG: startup process (PID 3452) exited with exit code 3
2010-04-21 13:34:58 MYTLOG: aborting startup due to startup process failure
Thanks and Regards
Yan Cheng CHEOK
--- On Wed, 4/21/10, Yan Cheng CHEOK <yccheok@yahoo.com> wrote:
> From: Yan Cheng CHEOK <yccheok@yahoo.com>
> Subject: unable to start postgresql server services (Windows XP/Professional/Service Pack3)
> To: pgsql-general@postgresql.org
> Date: Wednesday, April 21, 2010, 10:04 AM
> 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@postgresql.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
>
>
>
>