Re: Questions on PostGreSQL Authentication mechanism...

On 02/02/10 09:58, dipti shah wrote:
> Techdb=# show hba_file;
> hba_file
> --------------------------------------
> /etc/postgresql/8.4/main/pg_hba.conf
> (1 row)

Ah! you're running a Debian-based system by the look of it.

> 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;
> ^

You would normally do so from the system shell rather than psql.
However, you can "shell out" with a backslash command in psql:
\! cat /etc/...

You might not have permission to view that file.

A full list of psql backslash commands are available in the manual
(client applications), psql man-page and by doing \? (or \h for sql help).

HTH

--
Richard Huxton
Archonet Ltd