Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Passwords in PSQL
- From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- To: Rafaqat Ali <smoken0(at)gmail(dot)com>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Passwords in PSQL
- Date: Mon, 25 Apr 2005 15:38:22 +0800
- Message-id: <426C9E6E(dot)2010709(at)familyhealth(dot)com(dot)au>
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. Chris
- References:
- Passwords in PSQL
- From: Rafaqat Ali
- Passwords in PSQL
- Prev by Date: Re: Passwords in PSQL
- Next by Date: simplify register_dirty_segment()
- Previous by thread: Re: Passwords in PSQL
- Next by thread: simplify register_dirty_segment()
- Indexes: