On Tue, 2010-02-02 at 16:09 -0300, Alvaro Herrera wrote: > Tim Bruce - Postgres escribió: > > On Tue, February 2, 2010 08:23, Alvaro Herrera wrote: > > > > 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; > > > > 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" > > Hmm, yeah, that's a shortcoming of the debian packaging, no doubt. Does > it not install symlinks in the actual data directory? If not, that > should be reported as a bug ... I disagree. Debian/Ubuntu use the postgresql.conf facilities to have a different postgresql.conf. This is a limitation within PostgreSQL. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general