Skip site navigation (1) Skip section navigation (2)

pg_hba

From: "Rob Abernethy IV" <abernethy(at)dynedge(dot)com>
To: "postgresql" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_hba
Date: 2002-12-31 07:09:06
Message-ID: 20021231150906.M90792@dynedge.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

  • Re: pg_hba at 2002-12-31 20:57:30 from Justin Georgeson
  • Re: pg_hba at 2002-12-31 21:22:40 from David F. Skoll

pgsql-admin by date

Next:From: Somasekhar BangaloreDate: 2002-12-31 09:17:42
Subject: Urgent help need on French language.
Previous:From: SenthilDate: 2002-12-31 05:10:54
Subject: Stored procedures doubts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group