Re: bad pg_hba.conf file

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <KeithW(at)narrowpathinc(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: bad pg_hba.conf file
Date: 2004-10-12 07:13:17
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4306AE8@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Keith Worthington
> Sent: 11 October 2004 19:49
> To: pgadmin-support(at)postgresql(dot)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

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-10-12 09:31:54 Re: Null boolean values show as false in the data
Previous Message Keith Worthington 2004-10-11 18:48:31 bad pg_hba.conf file