On Mon, Dec 12, 2016 at 6:56 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ram DBA <postgresdbas@gmail.com> writes: > There are frequent errors in our postgresql.log. > Though they aren't harmful to the database, would like to understand the > cause of it.
Something's scanning your postmaster port once a second, ie, opening a connection and then closing it without sending anything. If you don't have a monitoring system that's supposed to be doing that, it would behoove you to find out where that traffic is coming from.
Recommend making your log_line_prefix more informative so you can get some additional information about the connection attempts. This is the standard one I use
The standard postgresql.conf file comes with an explanation for what all these special values mean as well as more available. You will have to reload the config to put it into affect. Just run this as a superuser: SELECT pg_reload_conf();