| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Gizem Acar <acargizem(at)hotmail(dot)com> |
| Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Password/Username |
| Date: | 2013-06-15 15:59:14 |
| Message-ID: | 51BC8F52.3050306@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2013-06-16 00:08:24 | Bug in foreign key constraint SQL |
| Previous Message | Gizem Acar | 2013-06-15 14:27:06 | Password/Username |