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: (view raw, whole thread or download thread mbox)
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         
>   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-2017 The PostgreSQL Global Development Group