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 BC3DD8B9F29 for ; Fri, 4 Feb 2005 23:51:08 +0000 (GMT) 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 55758-10 for ; Fri, 4 Feb 2005 23:51:02 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0AC878B9C91 for ; Fri, 4 Feb 2005 23:51:02 +0000 (GMT) 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 j14NorJq018554; Fri, 4 Feb 2005 18:50:53 -0500 (EST) To: Michael Klatt Cc: pgsql-admin@postgresql.org Subject: Re: Recovery using Online Backup+WAL and broken passwords In-reply-to: <420402AB.5060202@olympus.net> References: <4203A249.1010409@olympus.net> <15237.1107536658@sss.pgh.pa.us> <420402AB.5060202@olympus.net> Comments: In-reply-to Michael Klatt message dated "Fri, 04 Feb 2005 15:18:03 -0800" Date: Fri, 04 Feb 2005 18:50:53 -0500 Message-ID: <18553.1107561053@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: 200502/43 X-Sequence-Number: 16211 Michael Klatt writes: > Tom Lane wrote: >> [ thinks about that... ] Hmm, you're right, there is no mechanism to >> cause the flat password file to be rebuilt after a restore. > Do you think a fix will show up in 8.0.2? Not sure; a proper fix may have to wait for 8.1. The ideas I've had so far about it require nontrivial code additions, and we generally don't backpatch changes like that when there's an easy workaround. regards, tom lane