RE: [INTERFACES] pgaccess on win95 connection

Поиск
Список
Период
Сортировка
От eem21@cam.ac.uk
Тема RE: [INTERFACES] pgaccess on win95 connection
Дата
Msg-id E11sbx1-0003in-00@orange.csi.cam.ac.uk
обсуждение исходный текст
Ответ на RE: [INTERFACES] pgaccess on win95 connection  (Bill Barnes <bbarnes@operamail.com>)
Список pgsql-interfaces
On 29 Nov, Bill Barnes wrote:
>>

> [ Snip config. hints]
> 
> Found in this file 2 lines:
>   'local              all
>           trust'
>   'host              all              127.0.0.1         255.255.255.255.   
> trust'
> While this is not the ultimate security :-) doesn't it render the host 
> accessible.

No.  These two lines allow (respectively) access from the server machine
over UDP and access from the server machine over TCP.  Neither line
allows access from outside the server machine.  What you want is
something like:

host    all    192.168.1.0    255.255.255.0        trust

where the two numbers are IP addresses and masks suitable for your LAN,
or

host    all    192.168.1.123    255.255.255.255        trust

where 192.168.1.123 is the IP address of the (single) Windows machine
from which you are connecting.  And of course you want to consider the
security implications of trusting the Windows machine to tell you who
is logged on, etc.  You may want to look at the other authentication
methods available.

> [ Snip more admin hints ]

HTH,

Ewan.


************




В списке pgsql-interfaces по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [INTERFACES] libpq + multiple connections ...
Следующее
От: eem21@cam.ac.uk
Дата:
Сообщение: Re: [INTERFACES] libpq + multiple connections ...