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

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 (view raw or flat)
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

pgadmin-support by date

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

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