From: | Paul Jungwirth <pj(at)illuminatedcomputing(dot)com> |
---|---|
To: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: invalid connection type "listen_addresses='*' |
Date: | 2014-07-10 22:43:36 |
Message-ID: | CA+6hpamxAs8wchzaoSotvHTT0KwGFa_QoSjBmgVCZ12-bKkRzg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> It is non-specific since it is assumed at this point in the documentation
>> that you realize ALL "configuration parameters" are defined in
>> postgres.conf or its includes.
I think the comments in pg_hba.conf are a lot more misleading than the
online documentation, and are more likely to be read. They say:
# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL
# listen on a non-local interface via the listen_addresses
# configuration parameter, or via the -i or -h command line switches.
Followed by four blank lines, then some more comments and the default
settings. It really invites the user to fill in that blank space with
a listen_addresses line.
Paul
On Thu, Jul 10, 2014 at 3:25 PM, David G Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> David G Johnston wrote
>>
>> Aram Fingal wrote
>>>>
>>>> "listen_addresses='*'" parameter doesn't belong in pg_hba.conf
>>>>
>>>> This parameter should be in postgresql.conf
>>>
>>>
>>> Thanks. That was really unclear, at least the way I followed the online
>>> documentation:
>>>
>>> http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html
>>>
>>> …even after following the link to the listen_addresses parameter.
>> It is non-specific since it is assumed at this point in the documentation
>> that you realize ALL "configuration parameters" are defined in
>> postgres.conf or its includes. The fact the comment is in a note, and
>> links elsewhere, implicitly reinforces that fact - if it belonged in the
>> pg_hba.conf file its description would be part of the normal document and
>> not a sidebar.
>>
>> Admittedly this is all perfectly clear when you actually understand
>> everything already. While the documentation may be unclear to you
>> unfortunately you are the only person in a long while to actually post the
>> complaint to the lists and so its hard to justify figuring out how to make
>> the documentation clearer. It is equally important not to be redundant,
>> verbose and/or repetitive. The occasional confusion making its way to the
>> list it preferred.
>
> All that said I would not be opposed to adding a parethetical to the note:
>
> "[...] value for the listen_addresses configuration parameter (in
> postgres.conf), since the default [...]"
>
> since indeed the reader's mind is on the pg_hba.conf file and so easing the
> context switch is an easy improvement.
>
> David J.
>
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/invalid-connection-type-listen-addresses-tp5811177p5811194.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
_________________________________
Pulchritudo splendor veritatis.
From | Date | Subject | |
---|---|---|---|
Next Message | Don Brown | 2014-07-10 23:56:06 | Windows Installation User account - Correct database for us |
Previous Message | David G Johnston | 2014-07-10 22:25:41 | Re: invalid connection type "listen_addresses='*' |