| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tim Bruce - Postgres <postgres(at)tbruce(dot)com> |
| Cc: | dipti shah <shahdipti1980(at)gmail(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Questions on PostGreSQL Authentication mechanism... |
| Date: | 2010-02-02 19:09:35 |
| Message-ID: | 20100202190935.GD4020@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ...
> It also won't allow use of the absolute path.
That's by design, yes.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wang, Mary Y | 2010-02-02 19:18:04 | Re: Startup proc 30595 exited with status 512 - abort and FATAL 2: XLogFlush |
| Previous Message | Tim Bruce - Postgres | 2010-02-02 18:44:04 | Re: Questions on PostGreSQL Authentication mechanism... |