From: | Mike Mascari <mascarm(at)mascari(dot)com> |
---|---|
To: | Balaji Venkatesan <balaji(dot)venkatesan(at)megasoft(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Setting Password |
Date: | 2001-10-10 10:29:38 |
Message-ID: | 3BC42312.32F3F6A6@mascari.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
You need to change the pg_hba.conf file in your PostgreSQL
installation so that "password" authentication is used. Check out:
http://www.postgresql.org/idocs/index.php?client-authentication.html
for details.
Hope that helps,
Mike Mascari
mascarm(at)mascari(dot)com
> Balaji Venkatesan wrote:
>
> Hi List,
> Iam pretty new to this list as well as PostgreSQL. I hope to
> find some crucial info from here.
> Thnx in advance to all those who would contribute to it.
>
> Iam basically an Oracle Consultant.
>
> At first i would like to clarify how to enforce password for a
> user i have created.
> I use the psql client to access the database and unless and until
> the -U option
> (psql template1 -U <user> ) is used, iam not prompted to enter any
> password.
> Even thou i enter a wrong password iam still allowed to log in.
> Is there any property needs to be altered to enforce the same ?
> Looking forward for some favourable responses.
> Regards
> Balaji
From | Date | Subject | |
---|---|---|---|
Next Message | Haller Christoph | 2001-10-10 11:37:51 | Re: Connections, table locks, disk space |
Previous Message | Balaji Venkatesan | 2001-10-10 10:21:44 | Setting Password |