Skip site navigation (1) Skip section navigation (2)

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: 2005-04-25 07:38:22
Message-ID: 426C9E6E.2010709@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
>        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

In response to

pgsql-hackers by date

Next:From: Qingqing ZhouDate: 2005-04-25 08:13:39
Subject: simplify register_dirty_segment()
Previous:From: Gavin SherryDate: 2005-04-25 07:36:42
Subject: Re: Passwords in PSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group