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 C05C58B9C50 for ; Tue, 22 Feb 2005 14:39:02 +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 83123-09 for ; Tue, 22 Feb 2005 14:38:53 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id E044B8B9B19 for ; Tue, 22 Feb 2005 14:38:56 +0000 (GMT) Received: (qmail 29469 invoked by uid 500); 22 Feb 2005 14:54:17 -0000 Date: Tue, 22 Feb 2005 08:54:17 -0600 From: Bruno Wolff III To: Zouari Fourat Cc: pgsql-admin@postgresql.org Subject: Re: postgres user, forgotten password Message-ID: <20050222145417.GE22550@wolff.to> Mail-Followup-To: Zouari Fourat , pgsql-admin@postgresql.org References: <621eda8a05022206077a5506c5@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <621eda8a05022206077a5506c5@mail.gmail.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/219 X-Sequence-Number: 16387 On Tue, Feb 22, 2005 at 15:07:45 +0100, Zouari Fourat wrote: > Hello, > i forgot the postgres user password, how to resolve this problem. > once i have my postgres user working, how to list all users on the server ? > thanks a bunch Edit pg_hba.conf to use trust or ident authentication for "postgres". You probably want to make sure there is no external access to the database while doing this. SELECT usename FROM pg_user;