Re: startup failed! fatal error

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Hero'" <herolin(at)yam(dot)com>, Jeff Lu <jklcom(at)mindspring(dot)com>, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: startup failed! fatal error
Date: 2002-01-07 09:52:59
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F7476F@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

There is a contrib utility (pg_resetxlog) that allows clearing of pg_xlog.
It may be worth trying this. Note though clearing the WAL files can leave
the database in an inconsistent state. If you can I'd make a back up of the
entire data area then ask on general or maybe bugs. I suspect some people
would be interested in working out exactly what is stopping it starting.
- Stuart

-----Original Message-----
From: Hero [mailto:herolin(at)yam(dot)com]
Sent: 05 January 2002 07:19
To: Jeff Lu; pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] startup failed! fatal error

> using 7.1.2
>
> UGENT
>
> Database startup failed
>
> DEBUG: redo done at (1, 3923880100)
> FATAL 2: XLogFlush: request is not satisfied
> postmaster: Startup proc 1016 exited with status 512 - abort
>
> What can I do to recover?
>
> Thanks

your database store file is bad,
you must be use initdb create new template,but remember your database will
be destory.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2002-01-09 12:21:51 Re: About patches to PostgreSQL 7.1.3 for readline 4.1 & 4.2 in Cygwin
Previous Message Jakob Lund 2002-01-05 22:48:35 Re: postgresql client under win 2k