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







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
Wed, 10 Oct 2001 15:51:44 +0530
"Balaji Venkatesan" <balaji.venkatesan@megasoft.com>
Setting Password
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@mascari.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

Wed, 10 Oct 2001 06:29:38 -0400
Mike Mascari <mascarm@mascari.com>
Re: Setting Password