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