Search Postgresql Archives

Re: invalid connection type "listen_addresses='*'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>> 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.g.johnston@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



-- 
_________________________________
Pulchritudo splendor veritatis.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux