X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6A194D9B52 for ; Wed, 9 Nov 2005 12:08:39 -0400 (AST) 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 81527-10 for ; Wed, 9 Nov 2005 16:08:36 +0000 (GMT) X-Greylist: delayed 03:07:19.025285 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id E5362D92C7 for ; Wed, 9 Nov 2005 12:08:32 -0400 (AST) Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by svr2.postgresql.org (Postfix) with ESMTP id 416BEF0FED for ; Wed, 9 Nov 2005 13:01:21 +0000 (GMT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 5BFE02BD7D; Wed, 9 Nov 2005 15:01:16 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 520DADC2EE; Wed, 9 Nov 2005 15:01:16 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 350929748D; Wed, 9 Nov 2005 15:01:16 +0200 (SAST) Date: Wed, 9 Nov 2005 15:01:16 +0200 From: Stef To: "mad" Cc: pgsql-admin@postgresql.org Subject: Re: resetting superuser password Message-ID: <20051109150116.4f9e8fd6@svb.ucs.co.za> In-Reply-To: <1131540234.526161.161670@g43g2000cwa.googlegroups.com> References: <1131540234.526161.161670@g43g2000cwa.googlegroups.com> X-Mailer: Sylpheed-Claws 1.9.6cvs1 (GTK+ 2.6.10; i486-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YEWH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@ X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.115 required=5 tests=[AWL=0.115] X-Spam-Score: 0.115 X-Spam-Level: X-Archive-Number: 200511/90 X-Sequence-Number: 19463 Just disable password checking in pg_hba.conf. mad mentioned : => I have lost the superuser (user postgres) password, but I still have => the unix root password. Is there anything I can do to reset the => postgres user's password (short of reinstalling Postgres)? => => Obviously, I can su to unix user postgres, but this does not seem to => advance my cause, as doing "psql -U postgres" still prompts me for a => password, which is not the same as the unix postgres user's password. => => OS: RedHat 9 => => Help! => => Thanks, => Marc => => => ---------------------------(end of broadcast)--------------------------- => TIP 3: Have you checked our extensive FAQ? => => http://www.postgresql.org/docs/faq =>