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

Re: pg_hba.conf and ssl problem has me stumped

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)au>
Cc: olly(at)lfix(dot)co(dot)uk, pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_hba.conf and ssl problem has me stumped
Date: 2005-10-13 00:16:12
Message-ID: 15539.1129162572@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)au> writes:
> On 12/10/2005, at 6:16 PM, Oliver Elphick wrote:
>> Please show us what you have in pg_hba.conf.

> Sure, though as I said it's the same machine connection...

> Not an awful lot,  as you see:

> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

> @remove-line-for-nolocal(at)# "local" is for Unix domain socket  
> connections only
> @remove-line-for-nolocal(at)local   all          
> all                               @authmethod@
> # IPv4 local connections:
> host    all         all         127.0.0.1/32          @authmethod@
> # webserver password access
> host    all         all         150.203.157.27/32       md5
> # IPv6 local connections:
> #host    all         all         ::1/128               @authmethod@

That is not your pg_hba.conf file.  It looks like an unmodified
pg_hba.conf.sample file ... which the postmaster would reject if
presented in that form, because the @-thingies aren't valid syntax.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Cath LawrenceDate: 2005-10-13 01:33:45
Subject: Re: pg_hba.conf and ssl problem has me stumped
Previous:From: Cath LawrenceDate: 2005-10-12 23:28:45
Subject: Re: pg_hba.conf and ssl problem has me stumped

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