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 2DE32D9BF7 for ; Wed, 9 Nov 2005 12:08:40 -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 86126-03 for ; Wed, 9 Nov 2005 16:08:38 +0000 (GMT) X-Greylist: delayed 03:15:26.322504 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id CB37CD99E9 for ; Wed, 9 Nov 2005 12:08:35 -0400 (AST) Received: from mail2.alphyra-evs.de (mail2.ecommit.de [195.145.58.246]) by svr2.postgresql.org (Postfix) with ESMTP id 67347F0B56 for ; Wed, 9 Nov 2005 12:53:13 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by mail2.alphyra-evs.de (Postfix) with ESMTP id 3FD39902; Wed, 9 Nov 2005 13:53:09 +0100 (CET) Received: from mail2.alphyra-evs.de (localhost [127.0.0.1]) by localhost (AvMailGate-2.0.2-14) id 13144-48DD5471; Wed, 09 Nov 2005 13:53:09 +0100 Received: by mail2.alphyra-evs.de (Postfix, from userid 6000) id 27FB1945; Wed, 9 Nov 2005 13:53:09 +0100 (CET) Received: from fandelm.tc.de (fandelm.tc.de [192.168.252.51]) by mail2.alphyra-evs.de (Postfix) with ESMTP id EF740902; Wed, 9 Nov 2005 13:53:08 +0100 (CET) Subject: Re: Fwd: resetting superuser password From: Martin Fandel To: mad7@runbox.com Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-ep2xNn9N3L0+WSiLd9rE" Date: Wed, 09 Nov 2005 13:47:54 +0100 Message-Id: <1131540474.7250.375.camel@fandelm.tc.de> Mime-Version: 1.0 X-Mailer: Evolution 2.0.1 X-AntiVirus: checked by AntiVir MailGate (version: 2.0.2-14; AVE: 6.32.0.58; VDF: 6.32.0.159; host: localhost) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.032 required=5 tests=[AWL=0.031, HTML_MESSAGE=0.001] X-Spam-Score: 0.032 X-Spam-Level: X-Archive-Number: 200511/91 X-Sequence-Number: 19464 --=-ep2xNn9N3L0+WSiLd9rE Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, which version of postgres do you have? Put this temporarly into the /var/lib/pgsql/data/pg_hba.conf: if postgres 8: local all postgres 127.0.0.1/32 trust if postgres 7: local all trust then connect to template1...: psql -U postgres -d template1 ...and set your password: alter user postgres with encrypted password 'blablubb'; i hope this works. regards, martin Am Mittwoch, den 09.11.2005, 13:38 +0100 schrieb Marc A. Donis: > 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 4: Have you searched our list archives? > http://archives.postgresql.org --=-ep2xNn9N3L0+WSiLd9rE Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

which version of postgres do you have? Put this temporarly into the /var/lib/pgsql/data/pg_hba.conf:

if postgres 8:
local    all         postgres     127.0.0.1/32 trust

if postgres 7:
local      all         trust

then connect to template1...:
psql -U postgres -d template1

...and set your password:
alter user postgres with encrypted password 'blablubb';

i hope this works.

regards,

martin

Am Mittwoch, den 09.11.2005, 13:38 +0100 schrieb Marc A. Donis:
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 4: Have you searched our list archives?
               http://archives.postgresql.org
--=-ep2xNn9N3L0+WSiLd9rE--