Using the command solve the problem. Bravo! D:\Program Files\PostgreSQL\8.4\bin>pg_resetxlog -f "D:\Program Files\PostgreSQL\8.4\data" Transaction log reset Thanks and Regards Yan Cheng CHEOK --- On Wed, 4/21/10, Yan Cheng CHEOK <yccheok@xxxxxxxxx> wrote: > From: Yan Cheng CHEOK <yccheok@xxxxxxxxx> > Subject: Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3) > To: pgsql-general@xxxxxxxxxxxxxx > Date: Wednesday, April 21, 2010, 1:40 PM > 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 <yccheok@xxxxxxxxx> > wrote: > > > From: Yan Cheng CHEOK <yccheok@xxxxxxxxx> > > Subject: unable to start postgresql server services > (Windows XP/Professional/Service Pack3) > > To: pgsql-general@xxxxxxxxxxxxxx > > 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@xxxxxxxxxxxxxx/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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
