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
