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