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

Adding usernames to pg_hba.conf

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Adding usernames to pg_hba.conf
Date: 2002-03-19 05:55:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
This patch completes the following TODO item:

	* Allow usernames to be specified directly in pg_hba.conf (Bruce)

Currently, we allow usernames in secondary password files, but this is a
very confusing feature.  This patch:

	o  removes secondary password file support
	o  adds a user name column just after the database column
	o  allows a comma separated list of usernames or databases
	o  allows another file to contain a list of username/databases 
	   by preceding the pg_hba.conf entry with '@'
	o  allow single or double-quoting of user/database names

See the documentation changes and new pg_hba.conf diffs for samples.

Is the '@' sign a good way to identify a file name?  Is putting the
username column just after the database column the right place for it?
  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-03-19 06:06:40
Subject: Re: Adding usernames to pg_hba.conf
Previous:From: Bruce MomjianDate: 2002-03-19 02:58:22
Subject: Re: truncate cleanup

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