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@xxxxxxxxx> wrote: > From: Scott Marlowe <scott.marlowe@xxxxxxxxx> > Subject: Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3) > To: "Yan Cheng CHEOK" <yccheok@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Date: Wednesday, April 21, 2010, 1:59 PM > On Tue, Apr 20, 2010 at 11:47 PM, Yan > Cheng CHEOK <yccheok@xxxxxxxxx> > 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. > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general