Re: Fwd: resetting superuser password

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Wed, 9 Nov 2005, Marc A. Donis wrote:

> 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)?

Edit pg_hba.conf and set the auth method to trust. Then reload postgresql.
This will stop PostgreSQL from asking you a password.

Regards,
- --
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDce8u4zE8DGqpiZARArkjAJ4jmuLYV6I3oLnTowbF3d0IOfDYTQCeKDqZ
je2SdfQvAxgOTUhirXlzq6A=
=8VN2
-----END PGP SIGNATURE-----
>From pgsql-admin-owner(at)postgresql(dot)org Wed Nov 9 08:45:34 2005
X-Original-To: pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id C1AB8D9B52
for <pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 9 Nov 2005 08:45:31 -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 24150-08
for <pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 9 Nov 2005 12:45:28 +0000 (GMT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
by svr1.postgresql.org (Postfix) with ESMTP id 5EB94D9B24
for <pgsql-admin(at)postgresql(dot)org>; Wed, 9 Nov 2005 08:45:30 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
by news.hub.org (8.13.1/8.13.1) with ESMTP id jA9CjSJS029170
for <pgsql-admin(at)postgresql(dot)org>; Wed, 9 Nov 2005 12:45:28 GMT
(envelope-from news(at)news(dot)hub(dot)org)
Received: (from news(at)localhost)
by news.hub.org (8.13.1/8.13.1/Submit) id jA9Chsoc028631
for pgsql-admin(at)postgresql(dot)org; Wed, 9 Nov 2005 12:43:54 GMT
(envelope-from news)
From: "mad" <mad7(at)runbox(dot)com>
X-Newsgroups: pgsql.admin
Subject: resetting superuser password
Date: 9 Nov 2005 04:43:54 -0800
Organization: http://groups.google.com
Lines: 15
Message-ID: <1131540234(dot)526161(dot)161670(at)g43g2000cwa(dot)googlegroups(dot)com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Complaints-To: groups-abuse(at)google(dot)com
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 webproxy:8080 (squid/2.5.STABLE6)
Complaints-To: groups-abuse(at)google(dot)com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=193.29.77.101;
posting-account=Dt2P9g0AAADP8RcM2SpCaszJUO-a1x9F
To: pgsql-admin(at)postgresql(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=-1.44 required=5 tests=[ALL_TRUSTED=-1.44]
X-Spam-Score: -1.44
X-Spam-Level:
X-Archive-Number: 200511/86
X-Sequence-Number: 19459

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