On 11/8/2012 2:05 PM, Rodrigo Pereira da Silva wrote:
> Hi Guys,
>
> We are having a problem with our pgsql 9.1 on
> Linux(Debian).
> Suddently, the database stop working and the logs
> shows the statements below just before the problem. Any thoughts?
Just a word of caution that there may be no cause/effect relationship
between the log messages and the non-working-ness.
PG will print this message in the log if any TCP client simply connects
to it, then closes the connection.
For example if you have some kind of service liveness checker (nagios,
etc) that checks that something is accepting connections, you'll see
these messages.
Note that they have time stamps exactly one minute apart.
>
> 2012-11-08 02:47:12.529 CST 08P01 509b7190.4583LOG: incomplete
> startup packet
> 2012-11-08 02:48:12.534 CST 08P01 509b71cc.458bLOG: incomplete
> startup packet
> 2012-11-08 02:49:12.541 CST 08P01 509b7208.4593LOG: incomplete
> startup packet