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@postgresql.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)