> Any one can connect to any database. If any one knows user
> name, he/she connect to db. I want to provide some security that no
> one can connect without providing passwords. postgres uses a function
> do_coonect() for this perpose. I provide it passwords but it let me
> connect to db with any passwords provided. Can any one tell me how to
> set passwords for db user. and how can I implement password protection
> in psql.
You have to edit your pg_hba.conf and change trust authentication to md5.
In response to
pgsql-hackers by date
|Next:||From: Qingqing Zhou||Date: 2005-04-25 08:13:39|
|Subject: simplify register_dirty_segment()|
|Previous:||From: Gavin Sherry||Date: 2005-04-25 07:36:42|
|Subject: Re: Passwords in PSQL|