| From: | Rasputin <rasputin(at)freebsd-uk(dot)eu(dot)org> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Password protection? |
| Date: | 2000-12-04 14:08:23 |
| Message-ID: | 20001204140823.A37054@dogma.freebsd-uk.eu.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Quick query -
I can't figure out how to password protect an username.
e.g. I'm trying to create
user: rasputin
password: obvious
createuser seems to work fine;
createuser -d -A -P -e
but psql never asks for the password, it just lets me in.
i.e. createdb -U rasputin babel
creates a database without prompting for a password.
I'm obviously missing something incredibly simple.
Postgres 7.0.3, all connections are local.
I tried tweaking the 'local' lines in
~postgres/data/pg_hba.conf (changed 'trust' to 'crypt')
and restarting postmaster, but that blocked the postgres user too!
I reckon it's that file I need to edit, but how?
(Or how do I set an initial password for the user 'postgres')
Cheers.
--
Rasputin
Jack of All Trades :: Master of Nuns
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-12-04 14:19:19 | Re: Your RDBMS Survey ... |
| Previous Message | The Hermit Hacker | 2000-12-04 13:58:06 | Re: Your RDBMS Survey ... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2000-12-04 16:21:27 | Re: Password protection? |
| Previous Message | DE WOLF PETER | 2000-12-04 11:08:29 |