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 E79858B9FF7 for ; Fri, 4 Feb 2005 16:27:05 +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 26697-02 for ; Fri, 4 Feb 2005 16:26:59 +0000 (GMT) Received: from twisp.olympus.net (twisp.olympus.net [65.117.224.70]) by svr1.postgresql.org (Postfix) with ESMTP id 2641D8B9F8D for ; Fri, 4 Feb 2005 16:26:58 +0000 (GMT) Received: from LoricaMail on twisp.olympus.net ([172.21.2.56] helo=twisp.olympus.net) by twisp.olympus.net with esmtp (Exim 4.42) id 1Cx6IK-0002AX-Qb for pgsql-admin@postgresql.org; Fri, 04 Feb 2005 08:26:56 -0800 Received: from tuk-dsl-226-242.olympus.net ([65.117.226.242]:33571 helo=[192.168.0.5]) by twisp.olympus.net with esmtpa (Exim 4.42) id 1Cx6ID-00028W-W8 for pgsql-admin@postgresql.org; Fri, 04 Feb 2005 08:26:50 -0800 Message-ID: <4203A249.1010409@olympus.net> Date: Fri, 04 Feb 2005 08:26:49 -0800 From: Michael Klatt User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Recovery using Online Backup+WAL and broken passwords Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virtual-Service: OlympusNet X-Exim-Id: 1Cx6ID-00028W-W8 X-Olympus-MailID-CF: 1Cx6ID-00028W-W8Feb04082650jcd X-Olympus-Virus: Scanned X-Olympus-OlympusNet: Initial processing complete X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/32 X-Sequence-Number: 16200 PostgreSQL 8.0.1 Linux FC2, 2.6.8 Hi, I'm very new to PostgreSQL. I've been the admin of several MySQL servers for years, but for various reasons we're switching to PostgreSQL. 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. This is what I've done: created a base backup (using online backup) created some users stopped postgresql restored postgresql from base backup (and added recovery.conf) started postgresql The logs indicate that everything went great. The archived and unarchived WAL files are restored/used and the database backup is brought up-to-date. The users exist in the system, but their passwords are broken. If I used "ALTER USER" to reset the password then I can access the database ok. I'm using md5 as the default encryption. I've tried crypt and that doesn't work either. It doesn't seem to matter whether I use ENCRYPTED or UNENCRYPTED when created the users. So....is there something in the way users are created from WAL files that doesn't properly restore passwords? Has anyone else ecountered this problem? Thanks! Michael