yogvinder wrote: > Hi All, > > I am having multiple postgresql 7.3(pretty old version now) on rhel4 > servers. Which 7.3? Are you aware the community doesn't even officially support them now? > I am getting the error MemoryContextAlloc: invalid request size on many of > these servers from time to time. > > On crawling through net, I have found that its because of some bad word > value in a variable length field which implies database corruption. A > possible solution to recover database is by deleting the corrupted row and > then continuing till all the bad rows are deleted. > > My Queries: > 1) What is the root cause? Why database is getting corrupted. Hardware problems or a bug in the code. If it's happening on a regular basis it might well be hardware. > 2) Is any newer version or patch can take care of this issue. The last download for 7.3 is 7.3.21 http://www.postgresql.org/ftp/source/OLD/ > 3) Any other solution for the same that can update the corrupted data. If you're using RHEL check with RedHat and see what the latest RPM they offer is. -- 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
