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

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'thelp 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

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
>
>
>      
>

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@yahoo.com> wrote:

> 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
> >
> >
> >      
> >
>
>
>
>

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.

Oh. Then do you know any way I may recover, without losing any transaction?

Thanks and Regards
Yan Cheng CHEOK


--- On Wed, 4/21/10, Scott Marlowe <scott.marlowe@gmail.com> wrote:

> 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.
>

On Wed, Apr 21, 2010 at 1:38 AM, Yan Cheng CHEOK <yccheok@yahoo.com> wrote:
> Oh. Then do you know any way I may recover, without losing any transaction?

Not in your situation, you did the best you could and got the db back up.