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 9B05A8B9E7F for ; Fri, 4 Feb 2005 17:04:49 +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 29701-03 for ; Fri, 4 Feb 2005 17:04:31 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 287F58B9B33 for ; Fri, 4 Feb 2005 17:04:30 +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 j14H4IYS015238; Fri, 4 Feb 2005 12:04:18 -0500 (EST) To: Michael Klatt Cc: pgsql-admin@postgresql.org Subject: Re: Recovery using Online Backup+WAL and broken passwords In-reply-to: <4203A249.1010409@olympus.net> References: <4203A249.1010409@olympus.net> Comments: In-reply-to Michael Klatt message dated "Fri, 04 Feb 2005 08:26:49 -0800" Date: Fri, 04 Feb 2005 12:04:18 -0500 Message-ID: <15237.1107536658@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/35 X-Sequence-Number: 16203 Michael Klatt writes: > I love the online backup feature, but I'm encountering a problem with > users restored from WAL files. It seems that after a restore, the > password for any user created since the base backup is broken. [ thinks about that... ] Hmm, you're right, there is no mechanism to cause the flat password file to be rebuilt after a restore. So newly created users won't be in it (and for that matter it won't reflect post-backup password changes for existing users). Just (re)assign any one user's password and things should be ok. Now that I think about it, this problem exists for ordinary crash recovery from WAL as well. We probably ought to just forcibly rebuild the flat file at conclusion of any recovery. Odd that it hadn't been noticed already. regards, tom lane