Re: Questions on PostGreSQL Authentication mechanism...

[dipti shah <shahdipti1980@xxxxxxxxx>]

Techdb=# show hba_file;
               hba_file
--------------------------------------
 /etc/postgresql/8.4/main/pg_hba.conf
(1 row)

 

Moreover, is there anyway to view content of this file from stored in above location "Techdb" command prompt itself.

 

Techdb=# cat  /etc/postgresql/8.4/main/pg_hba.conf;
ERROR:  syntax error at or near "cat"
LINE 1: cat  /etc/postgresql/8.4/main/pg_hba.conf;
        ^

Thanks,

Dipti

On Tue, Feb 2, 2010 at 3:25 PM, dipti shah <shahdipti1980@xxxxxxxxx> 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?

 

Thanks,

Dip

On Mon, Feb 1, 2010 at 9:43 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote:

dipti shah escribió:

> Thanks Richard. those chapters are very useful. I got to know most of
> concepts but didn't find the location of pg_hba.conf file so that I can
> verify it. I have connected to my database using "postgres" user. Could you
> tell me how to open pg_hba.conf file?

Run this:
       SHOW hba_file;

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.