Re: PostgreSQL DB checkpoint error! - Mailing list pgsql-admin

From David G. Johnston
Subject Re: PostgreSQL DB checkpoint error!
Date
Msg-id CAKFQuwaQQake1xi35to9Sx_57O9kbhNtNRm9-ZsoaNEGG=cE=g@mail.gmail.com
Whole thread Raw
In response to PostgreSQL DB checkpoint error!  (Ashok kumar Mani <amani@accelaero.com>)
Responses RE: PostgreSQL DB checkpoint error!  (Ashok kumar Mani <amani@accelaero.com>)
List pgsql-admin
There are no errors in the logs you provided, only “weak warnings”

On Monday, April 27, 2020, Ashok kumar Mani <amani@accelaero.com> wrote:


Database is getting hung every day at 5AM. I found the below message from log file , Could you please help me , should I need to increase the max_wal_size value ?

 Probably not, you should probably look for insertion code that does high volume via the insert sql command without transactions and/or batching.

Why it say “incomplete startup packet” in the log.


Because you have a software client beginning but not completing a connection to the database.  Usually its some form of monitoring.

David J.

pgsql-admin by date:

Previous
From: Ashok kumar Mani
Date:
Subject: PostgreSQL DB checkpoint error!
Next
From: Ashok kumar Mani
Date:
Subject: RE: PostgreSQL DB checkpoint error!