Re: bad pg_hba.conf file - Mailing list pgadmin-support

From Dave Page
Subject Re: bad pg_hba.conf file
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4306AE8@ratbert.vale-housing.co.uk
Whole thread Raw
In response to bad pg_hba.conf file  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgadmin-support

> -----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


pgadmin-support by date:

Previous
From:
Date:
Subject: Re: I can't choose Catalan language in the list!
Next
From: Andreas Pflug
Date:
Subject: Re: Null boolean values show as false in the data