Re: remote connections to Windows based server

Поиск
Список
Период
Сортировка
От Paul Forgey
Тема Re: remote connections to Windows based server
Дата
Msg-id B69C8279-93B5-476F-95D3-C0EFDC3C4791@aphrodite.com
обсуждение исходный текст
Ответ на Re: remote connections to Windows based server  (Jeff Frost <jeff@frostconsultingllc.com>)
Список pgsql-admin
On Nov 17, 2006, at 2:41 PM, Jeff Frost wrote:

> On Fri, 17 Nov 2006, Paul Forgey wrote:
>
>> I am running the pre-built Windows version of postgresql 8.1.  I
>> have a local LAN with a 10.6/16 network. Apparently there's
>> something more than what's in the FAQ or my interpretation of the
>> manual to get remote connections working.
>>
>> pg_hba.conf:
>> host all all 10.6/16 md5
>> host all all 127.0.0.1/32 md5
>
> Paul,
>
> Did you try:
> host all all 10.6.0.0/16 md5
>
> ?
>
> I believe you must list all 4 octets of the subnet.  It says this
> in the docs:
>
> The mask length indicates the number of high-order bits of the
> client IP address that must match. Bits to the right of this must
> be zero in the given IP address.
>
> Which tells me the 0s have to be there.
>

D'oh yes, I overlooked that. specifying 10.6.0.0 worked.

Thank you.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: remote connections to Windows based server
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: 100% failover + replication solution