| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | dipti shah <shahdipti1980(at)gmail(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Questions on PostGreSQL Authentication mechanism... |
| Date: | 2010-02-02 16:23:38 |
| Message-ID: | 20100202162338.GB4020@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2010-02-02 16:50:25 | Re: Connect RDF to PostgreSQL? |
| Previous Message | Tom Lane | 2010-02-02 16:11:20 | Re: ERROR: relation xxx is still open (Re: Use Trigger to Remove Table ... ) |