On Thu, Jul 16, 2015 at 5:18 PM, M Tarkeshwar Rao <m.tarkeshwar.rao@xxxxxxxxxxxx> wrote: > a. How can we prevent "This has been seen to occur with buggy kernels; > consider updating your system" alarm ? > b. how can resolve "This has been seen to occur with buggy kernels; consider > updating your system" alarm ? This defense has been added by this commit some time ago: commit: ffae5cc5a6024b4e25ec920ed5c4dfac649605f8 author: Tom Lane <tgl@xxxxxxxxxxxxx> date: Mon, 25 Sep 2006 22:01:10 +0000 Add a check to prevent overwriting valid data if smgrnblocks() gives a wrong answer, as has been seen to occur with a buggy Linux kernel. Not really our bug, but it's a simple test in a seldom-used control path, so might as well have a defense. And if you look at the comment on top of this error message this code is a protection against lseek(SEEK_END) that may be buggy on some old kernels. Hence the answer to both questions is in the error message: upgrade your system to a newer kernel or migrate to a newer server. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general