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@gmail.com> 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@commandprompt.com> 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.
