Thread: bad pg_hba.conf file

bad pg_hba.conf file

From
"Keith Worthington"
Date:
Hi All,

When I try to connect to the database server I get an error indicating my
pg_hba.conf file is bad.  Here are the only two lines that I have.  Any
comments pointing me in the correct direction  would be appreciated.

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
local  all      all
host    all         all         192.168.7.0         255.255.255.0   trust

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com



Re: bad pg_hba.conf file

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Keith Worthington
> Sent: 11 October 2004 19:49
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] bad pg_hba.conf file
>
> Hi All,
>
> When I try to connect to the database server I get an error
> indicating my pg_hba.conf file is bad.  Here are the only two
> lines that I have.  Any comments pointing me in the correct
> direction  would be appreciated.
>
> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK
>       METHOD
> local  all      all
> host    all         all         192.168.7.0
> 255.255.255.0   trust

This should really be on a PostgreSQL list, not a pgadmin one, but
seeing as it's a quickie, you appear to be missing the method value on
the 'local all all' entry. You need to specify how matches to that line
will be authenticated - eg. md5, trust etc.

Regards, Dave