Re: resetting postgres password

From: John DeSoi <desoi(at)pgedit(dot)com>
To: D A GERM <dgerm(at)shepherd(dot)edu>
Cc: PGSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: resetting postgres password
Date: 2005-04-06 12:39:50
Message-ID: F7EBAC5A-A698-11D9-86D9-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 6, 2005, at 8:22 AM, D A GERM wrote:

> What is the easiest way to reset the postgres user password?

Using the ALTER USER command. If you don't know the password,
temporarily modify the pg_hba.conf file to allow local connections
without a password ('trust'). You can then login without the password
and reset it.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-04-06 13:07:36 Re: very slow after a while...
Previous Message Costin Manda 2005-04-06 12:24:31 Re: very slow after a while...