Re: Questions on PostGreSQL Authentication mechanism...
| От | dipti shah |
|---|---|
| Тема | Re: Questions on PostGreSQL Authentication mechanism... |
| Дата | |
| Msg-id | d5b05a951002020158u8f1f421n3bbdb34902151fc6@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Questions on PostGreSQL Authentication mechanism... (dipti shah <shahdipti1980@gmail.com>) |
| Ответы |
Re: Questions on PostGreSQL Authentication mechanism...
Re: Questions on PostGreSQL Authentication mechanism... |
| Список | pgsql-general |
Techdb=# show hba_file;
hba_file
--------------------------------------
/etc/postgresql/8.4/main/pg_hba.conf
(1 row)
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;
ERROR: syntax error at or near "cat"
LINE 1: 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;
^
Thanks,
Dipti
On Tue, Feb 2, 2010 at 3:25 PM, dipti shah <shahdipti1980@gmail.com> wrote:
Thanks Richard and Alvaro. The "show hba_file" is great solution. Thanks a ton. Could you tell me from where to get all such commands?Thanks,DipOn Mon, Feb 1, 2010 at 9:43 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote:dipti shah escribió:> Thanks Richard. those chapters are very useful. I got to know most ofRun this:
> concepts but didn't find the location of pg_hba.conf file so that I can
> verify it. I have connected to my database using "postgres" user. Could you
> tell me how to open pg_hba.conf file?
SHOW hba_file;
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-general по дате отправления: