Password protection?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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 ...

Browse pgsql-novice by date

  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