Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAKTk-0003c3-SR for pgsql-admin@arkaria.postgresql.org; Mon, 03 Feb 2014 14:26:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WAKTj-0004Mq-2s for pgsql-admin@arkaria.postgresql.org; Mon, 03 Feb 2014 14:26:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAKTU-00041F-EE for pgsql-admin@postgresql.org; Mon, 03 Feb 2014 14:26:12 +0000 Received: from smtp-out-2.mgm.tiscali.com ([213.205.37.14] helo=imp.mgm.tiscali.it) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAKTS-00086x-3x for pgsql-admin@postgresql.org; Mon, 03 Feb 2014 14:26:12 +0000 Received: from [192.168.1.8] ([93.61.33.196]) by smtp-out-2.mgm.tiscali.com with id MqS81n0014DtrJt01qS8wX; Mon, 03 Feb 2014 15:26:09 +0100 x-auth-user: sharon@erabyte.it Message-ID: <52EFA700.6020609@erabyte.it> Date: Mon, 03 Feb 2014 15:26:08 +0100 From: sharon User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Admin user issue: unable to login after changing password Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, I'm using postgres 9.2 on windows 7. I've changed the password of postgres user with pgadmin but now i'm unable to log in. There are two users accounts but only one is the admin. The problem is that the postgres' user expire date is set in 1970, I can see this from the other account. Is possible to replace users with a configuration hack? Or is possible to install everything again without loosing database's data? Is there a way to solve this issue? Thank you Sharon -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin