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 5E4ACD9421 for ; Wed, 9 Nov 2005 08:38:24 -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 26162-02 for ; Wed, 9 Nov 2005 12:38:19 +0000 (GMT) X-Greylist: delayed 01:56:56.800823 by SQLgrey- Received: from cujo.runbox.com (aibo.runbox.com [193.71.199.94]) by svr1.postgresql.org (Postfix) with ESMTP id 82877D93E9 for ; Wed, 9 Nov 2005 08:38:21 -0400 (AST) Received: from [10.9.9.131] (helo=garm.runbox.com) by greyhound.runbox.com with esmtp (Exim 4.34) id 1EZpDc-0008WN-43 for pgsql-admin@postgresql.org; Wed, 09 Nov 2005 13:38:24 +0100 Received: from mail by garm.runbox.com with local (Exim 4.50) id 1EZpDc-0001mP-2c for pgsql-admin@postgresql.org; Wed, 09 Nov 2005 13:38:24 +0100 Content-Type: text/plain; charset="iso-8859-15" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Received: from [193.29.77.101] by www.runbox.com with http (uid:69848) (RMM 4.0); for ; Wed, 09 Nov 2005 12:38:24 GMT From: "Marc A. Donis" Reply-To: mad7@runbox.com To: pgsql-admin@postgresql.org Subject: Fwd: resetting superuser password Date: Wed, 09 Nov 2005 13:38:24 +0100 (CET) X-Sender: 69848 X-Mailer: RMM Message-Id: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/84 X-Sequence-Number: 19457 I have lost the superuser (user postgres) password, but I still have the un= ix 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 advanc= e my cause, as doing "psql -U postgres" still prompts me for a password, wh= ich is not the same as the unix postgres user's password.=20 OS: RedHat 9 Help! Thanks, Marc