On 6/3/17, 22:42, "pgsql-admin-owner@xxxxxxxxxxxxxx on behalf of kschindl" <pgsql-admin-owner@xxxxxxxxxxxxxx on behalf of chuck666xx@xxxxxxxxx> wrote:
Tom Lane-2 wrote
I'd counsel looking into the postmaster log file. The described symptoms
sound like the postmaster is failing to start when given this setting,
and the log should offer some clue as to why.
I think we've seen similar reports that eventually traced to local DNS
misconfiguration, but that's theorizing in advance of the evidence.
regards, tom lane
thx.
That is what the log says:
2017-06-04 10:25:38 ICT [938-1] LOG: invalid connection type
"listen_addresses"
2017-06-04 10:25:38 ICT [938-2] CONTEXT: line 74 of configuration file
"/etc/postgresql/9.5/main/pg_hba.conf"
2017-06-04 10:25:38 ICT [938-3] FATAL: could not load pg_hba.conf
That is line 74
listen_addresses = '*'
copied from manual
so i am lost
The listen_addresses parameter goes in: postgresql.conf
doug
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
