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 file or 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 file or 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 <ycch...@yahoo.com> wrote: > From: Yan Cheng CHEOK <ycch...@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 > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
