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@xxxxxxxxxxxxxx) > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
