Re: Password/Username - Mailing list pgadmin-support

From Raymond O'Donnell
Subject Re: Password/Username
Date
Msg-id 51BC8F52.3050306@iol.ie
Whole thread Raw
In response to Password/Username  (Gizem Acar <acargizem@hotmail.com>)
List pgadmin-support
On 15/06/2013 15:27, Gizem Acar wrote:
> Hello,
> 
> 
> i forgot my password and user name. Could you tell me how can i fix
> this?

Assuming you mean the username and password for connecting to
PostgreSQL, you could edit the pg_hba.conf file and change the value
under "METHOD" on the applicable rule to "trust". Reload the server to
make the new setting take effect, and then you'll be able to log in
without a password. Reset your password; and then change the
authentication method back to "md5" or whatever it was before (don't
forget to reload once more).

HTH,

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



pgadmin-support by date:

Previous
From: Gizem Acar
Date:
Subject: Password/Username
Next
From: "David Rowley"
Date:
Subject: Bug in foreign key constraint SQL