| From: | Paul Forgey <paulf(at)aphrodite(dot)com> |
|---|---|
| To: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: remote connections to Windows based server |
| Date: | 2006-11-18 00:22:58 |
| Message-ID: | B69C8279-93B5-476F-95D3-C0EFDC3C4791@aphrodite.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-11-18 00:30:53 | Re: 100% failover + replication solution |
| Previous Message | Tom Lane | 2006-11-17 23:26:16 | Re: remote connections to Windows based server |