From: | "utsav(dot)turray" <utsav(dot)turray(at)newgen(dot)co(dot)in> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC |
Date: | 2009-08-17 10:12:36 |
Message-ID: | 25004248.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Richard,
I can't exclude the table because it is important table.
Is there any way , i could get the data back.
Utsav
Richard Huxton wrote:
>
> utsav.turray wrote:
>> Dear All,
>>
>> I am using postgres 7.3 version on RHEL 4.0.
>> My database has been restored.
>> All tables all working fine i.e select , update but on a particular table
>> its showing error
>>
>> ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only
>> to
>> AF/50F15ABC
>>
>> I have searched other threads, it shows the problem may be due to garbage
>> in
>> the LSN field of a page header.
>> Now what is the solution to this problem.
>
> 1. Dump the database immediately so you have a backup.
> 2. Check that you can restore from that backup.
> 3. Make sure you are running the latest release of 7.3 - 7.3.21
> available from ftp://ftp-archives.postgresql.org/
> 4. Upgrade as soon as is practical 7.4 was released in 2003 and we are
> currently on 8.4
> 5. Test your hardware - disk errors might have caused this.
>
> If you are having problems dumping the database you might need to
> identify which table and set of records is giving you problems and
> exclude those.
>
> --
> Richard Huxton
> Archonet Ltd
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
View this message in context: http://www.nabble.com/ERROR%3A--XLogFlush%3A-request-AF-5703EDC8-is-not-satisfied-----flushed-only-to-AF-50F15ABC-tp24895088p25004248.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Sergio Borgonovo | 2009-08-17 10:36:49 | design, plpgsql and sql injection in dynamically generated sql |
Previous Message | Jorge Daine Quiambao | 2009-08-17 09:40:59 | Re: Requesting help on PostgreSQL Replication |