Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B19969FBB03 for ; Wed, 2 May 2007 08:13:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04157-10 for ; Wed, 2 May 2007 08:13:17 -0300 (ADT) X-Greylist: delayed 00:16:59.000468 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 303BE9FBB58 for ; Wed, 2 May 2007 08:13:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from cefni.aber.ac.uk (unknown [144.124.16.40]) by svr4.postgresql.org (Postfix) with ESMTP id 31F8E5AF88C for ; Wed, 2 May 2007 10:56:17 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=cefni.aber.ac.uk) by cefni.aber.ac.uk with esmtp (Exim 4.62) (envelope-from ) id 1HjCVK-0001Jt-7T for pgsql-admin@postgresql.org; Wed, 02 May 2007 11:56:14 +0100 Received: from pc2axs.dcs.aber.ac.uk ([193.60.11.82] helo=pc2axs) by cefni.aber.ac.uk with esmtp (Exim 4.62) (envelope-from ) id 1HjCUv-0001G8-70 for pgsql-admin@postgresql.org; Wed, 02 May 2007 11:55:50 +0100 From: "Sandy Spence" To: Subject: pg_user pg_shadow out of sync Date: Wed, 2 May 2007 11:55:51 +0100 Message-ID: <002401c78ca8$734effe0$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 thread-index: AceMqHMwK5sdfj7ITZyEzmFQ4SVURw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Sophos-Scanned: from axs@aber.ac.uk virus scanned OK X-UWA-Mid: 1HjCUv-0001G8-70 X-UWA-Originating-IP: 193.60.11.82 X-UWA-Bounce-Filter: KszQHkEqO6 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/14 X-Sequence-Number: 25334 Hi All, Can any one tell me what I need to do to get this back on if I do a select on pg_user for a particular user and then do a select on users for the same user the expiry and valuntil columns are different? How do I get these to match? Cheers, Sandy