I am connected to database as postgres user. '\!exec ..' doesn't work if I connect to the database from other host but it does work if I connect to the database from server where I have PostGreSQL installed. pg_read_file doesn't work in any case.
Techdb=# \! exec cat /etc/postgresql/8.4/main/pg_hba.conf cat: cannot open /etc/postgresql/8.4/main/pg_hba.conf Techdb=# select pg_read_file('pg_hba.conf', 0, 8192); ERROR: could not open file "pg_hba.conf" for reading: No such file or directory Thanks, Dipti On Wed, Feb 3, 2010 at 12:14 AM, Tim Bruce - Postgres <postg...@tbruce.com>wrote: > On Tue, February 2, 2010 08:23, Alvaro Herrera wrote: > > dipti shah escribió: > >> 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; > > > > Probably pg_read_file(): > > > > select pg_read_file('pg_hba.conf', 0, 8192); > > > > Note that pg_read_file only allows paths relative to $PGDATA, which is > > what you get from SHOW data_directory; > > > > -- > > Alvaro Herrera > > http://www.CommandPrompt.com/ <http://www.commandprompt.com/> > > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > > Since the pg_hba.conf file is located in the /etc path, the pg_read_file > command fails with an error of > > "could not open file "pg_hba.conf" for reading: No such file or direcotry" > > It also won't allow use of the absolute path. > > The answer I found was to use the following command: > > postgres=# \! exec cat /etc/postgresql/8.3/main/pg_hba.conf > > Tim > -- > Timothy J. Bruce > > Registered Linux User #325725 > >