On 4 Dec 2000, at 14:08, Rasputin wrote:
> I can't figure out how to password protect an username.
Change the line in pg_hba.conf to "password", not trust. Trust
means that the user is never prompted for a password. (this is the
default for local connections, which seems much to open for my
tastes; unfortunately, many people create their "host" Internet
lines, never having changed this.)
To create a password for the postgres user,
ALTER USER postgres WITH PASSWORD 'xxxxx';
or, to see what's really happening, look in pg_password.
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)