unable to start postgresql server services (Windows XP/Professional/Service Pack3)

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

     

From: Yan Cheng CHEOK <yccheok@yahoo.com>
Subject: Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)
To: pgsql-general@postgresql.org
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@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

     

From: Scott Marlowe <scott.marlowe@gmail.com>
Subject: Re: [GENERAL] unable to start postgresql server services (Windows XP/Professional/Service Pack3)
To: "Yan Cheng CHEOK" <yccheok@yahoo.com>
Cc: pgsql-general@postgresql.org
Date: Wednesday, April 21, 2010, 1:59 PM
On Tue, Apr 20, 2010 at 11:47 PM, Yan
Cheng CHEOK <yccheok@yahoo.com>
wrote:

Using the command solve the problem. Bravo!

D:\Program Files\PostgreSQL\8.4\bin>pg_resetxlog -f

"D:\Program Files\PostgreSQL\8.4\data"

Just so you know you may (likely will) lose some
transactions.