Re: writing block 6850 of relation 1663/17231/1259 - Mailing list pgsql-general

From Craig Ringer
Subject Re: writing block 6850 of relation 1663/17231/1259
Date
Msg-id 4E6EE030.6060902@ringerc.id.au
Whole thread Raw
In response to writing block 6850 of relation 1663/17231/1259  (Mudit Mishra <Mudit.Mishra@suk.sas.com>)
List pgsql-general
On 11/09/2011 10:37 PM, Mudit Mishra wrote:
> Can anyone help me to fix this issue?
>
> I keep getting following errors in the log. I do not have a backup of the database and want to recover the database
asmuch as possible from this error. 
>
> 2011-09-09 11:06:39 PANIC:  xlog flush request 2/190490D8 is not satisfied --- flushed only to 2/19004190
> 2011-09-09 11:06:39 CONTEXT:  writing block 6850 of relation 1663/17231/1259

Before you do ANYTHING else, copy your data directory to other storage.
Do not try to "fix" anything until you have made a copy of your data
directory. Copy it while the server is stopped.


--
Craig Ringer

pgsql-general by date:

Previous
From: pasman pasmański
Date:
Subject: Re: Compatibility 9.1rc and 9.1.0
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: 9.0, 9.1 RPM based parallel execution?