X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7CF595334C for ; Fri, 1 Apr 2005 17:10:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76369-01 for ; Fri, 1 Apr 2005 16:10:09 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 07A7F53326 for ; Fri, 1 Apr 2005 17:10:08 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j31GA5iJ006884; Fri, 1 Apr 2005 11:10:05 -0500 (EST) To: "L.Boldareva" Cc: pgsql-admin@postgresql.org Subject: Re: How to recover when can't start database In-reply-to: References: <6531.1112368973@sss.pgh.pa.us> Comments: In-reply-to "L.Boldareva" message dated "Fri, 01 Apr 2005 17:57:55 +0200" Date: Fri, 01 Apr 2005 11:10:05 -0500 Message-ID: <6883.1112371805@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/17 X-Sequence-Number: 17030 "L.Boldareva" writes: > Here is how I got it crashed: > I compiled a c-procedure and copied the .so file to its place exactly at a > time when (quite unfortunately) another query was running, that used that > library. Hmm, at worst that should only crash one backend, not result in bad data getting into the WAL log. If there was no filesystem crash then I have to suppose that the page number entered in the WAL page split record was wrong ... but how could that happen if the same page number had just been used successfully to read the page? regards, tom lane