Re: pg_hba

Try leaving the IP fields blank, local uses a unix domain socket.

Rob Abernethy IV wrote:
> Is there any problem with this line from my pg_hba.conf file:
>
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
> local all all 0.0.0.0 0.0.0.0 md5
>
> I get this error when I try to connect:
>
> LOG: parse_hba: invalid syntax in pg_hba.conf file at line 90, token "0.0.0.0"
> FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for details
>
> I'm using version 7.3.1 and postmaster is running with both tcp/ip and ssl
> turned on. Does the IP address need to be in quotes or anything? Is this
> different from previous versions?
>
> --
> Robert Abernethy IV
> Dynamic Edge, Inc.
> 734.975.0460
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Justin Georgeson
UnBound Technologies, Inc.
http://www.unboundtech.com
Main 713.329.9330
Fax 713.460.4051
Mobile 512.789.1962

5295 Hollister Road
Houston, TX 77040
Real Applications using Real Wireless Intelligence(tm)