Re: Questions on PostGreSQL Authentication mechanism...

[dipti shah <shahdipti1980@xxxxxxxxx>]

Wow!!..that was too quick. Thanks Richard.

On Tue, Feb 2, 2010 at 3:29 PM, Richard Huxton <dev@xxxxxxxxxxxx> wrote:

On 02/02/10 09:55, dipti shah wrote:

Thanks Richard and Alvaro. The "show hba_file" is great solution. Thanks a
ton. Could you tell me from where to get all such commands?

All the configuration settings are listed in Chapter 18:
http://www.postgresql.org/docs/8.4/static/runtime-config.html

You'll also find details in the SQL reference for SET and SHOW:
http://www.postgresql.org/docs/8.4/static/sql-set.html
http://www.postgresql.org/docs/8.4/static/sql-show.html

"SHOW ALL" will list all the settings in one big table.

--
 Richard Huxton
 Archonet Ltd