Search Postgresql Archives

Re: ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux