From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ashok kumar Mani <amani(at)accelaero(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL DB checkpoint error! |
Date: | 2020-04-28 06:26:57 |
Message-ID: | CAKFQuwaQQake1xi35to9Sx_57O9kbhNtNRm9-ZsoaNEGG=cE=g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
There are no errors in the logs you provided, only “weak warnings”
On Monday, April 27, 2020, Ashok kumar Mani <amani(at)accelaero(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ashok kumar Mani | 2020-04-28 06:31:52 | RE: PostgreSQL DB checkpoint error! |
Previous Message | Ashok kumar Mani | 2020-04-28 06:13:31 | PostgreSQL DB checkpoint error! |