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