Re: A change in the Debian install

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rob stone <floriparob(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: A change in the Debian install
Date: 2017-04-06 04:05:51
Message-ID: 16897.1491451551@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rob stone <floriparob(at)gmail(dot)com> writes:
> Upgraded to version 9.6.2-2 and these are the log entries on start-up:-

> 2017-04-05 08:03:29 AESTLOG:  test message did not get through on
> socket for statistics collector

This is not something that would be affected by any Postgres setting;
the stats collector always depends on a loopback TCP connection to
"localhost", and has done so since day one. If it was working before,
you need to look at what you changed related to network and firewall
configuration. These symptoms looks like some kernel firewall rule
deciding to block local-loopback TCP traffic, for what that's worth.

(But ... these statements are based on an assumption of out-of-the-
box Postgres behavior. I would not exactly put it past the Debian
packagers to have decided to change this for reasons of their own,
and their track record of telling us about such decisions is many
miles south of abysmal. So you might look at whatever patches
are in the Debian package to see if there's anything touching
pgstat.c's socket-setup logic.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-04-06 04:14:44 Re: A change in the Debian install
Previous Message Patrick B 2017-04-06 03:54:50 regexp_matches where clause - PG 9.1