Обсуждение: pg_hba

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

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)

On Tue, 31 Dec 2002, 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

A type of "local" doesn't take IP-ADDRES or IP-MASK.  It's a UNIX-domain
socket, so those values are not meaningful.

Try:

    local    all    all    md5

Regards,

David.