From: | Stef <svb(at)ucs(dot)co(dot)za> |
---|---|
To: | "mad" <mad7(at)runbox(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: resetting superuser password |
Date: | 2005-11-09 13:01:16 |
Message-ID: | 20051109150116.4f9e8fd6@svb.ucs.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
=>
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin Giedz | 2005-11-09 14:26:51 | Xeon vs Opteron - tests and questions |
Previous Message | patrick hoogendijk | 2005-11-09 12:56:01 | Is there a way to check execution progress of a query? |