|
Home > Archive > PostgreSQL Discussion > May 2005 > a way to reset the postgres password to nothing..
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
a way to reset the postgres password to nothing..
|
|
|
| hi...
i've set up a postrges db, and i can get to it using a user/passwd. however,
when i su into the postgres user, and i try to do a 'psql -U postgres' it
prompts me for the password.. i have no idea what the password would be.. i
created everything, and thought i had just given it a blank password...
any ideas as to how i can change this, or reset the passwd to nothing...
thanks
bruce
bedouglas@earthlink.net
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
| |
| Richard Huxton 2005-05-31, 7:23 am |
| bruce wrote:
> hi...
>
> i've set up a postrges db, and i can get to it using a user/passwd. however,
> when i su into the postgres user, and i try to do a 'psql -U postgres' it
> prompts me for the password.. i have no idea what the password would be.. i
> created everything, and thought i had just given it a blank password...
>
> any ideas as to how i can change this, or reset the passwd to nothing...
It's possible the installation setup a password. You might want to run a
search for files called ".pgpass"
Update your pg_hba.conf to "trust" for local connections, connect as
user postgres, set your password, undo your changes to pg_hba.conf.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
|
|