RE: PostgreSQL DB checkpoint error!

Classification: External

Hi Rui DeSousa
Do I need to restart the postgresql service for log_checkpoints to make it active . I would like to enable this parameter temporarily and check it?

postgres=# show log_checkpoints;
log_checkpoints
-----------------
off
(1 row)

postgres=# show shared_buffers;
shared_buffers
----------------
60GB
(1 row)

postgres=# show max_wal_size;
max_wal_size
--------------
2GB
(1 row)

postgres=# show wal_buffers;
wal_buffers
-------------
16MB
(1 row)

postgres=#

Best Wishes,

Ashokkumar Mani
Database Architect\DBA
OCP | AWSCSA | M103

From: Rui DeSousa <rui(at)crazybean(dot)net>
Sent: Tuesday, April 28, 2020 10:41 AM
To: Ashok kumar Mani <amani(at)accelaero(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org; pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL DB checkpoint error!

Information Security Email Alert: This email is from an EXTERNAL source. Please use caution when clicking on links or opening attachments from an unknown or suspicious sender. To report a suspected phishing email, Send us an Email on Servicedesk(at)accelaero(dot)com<mailto:Servicedesk(at)accelaero(dot)com>

On Apr 28, 2020, at 2:13 AM, Ashok kumar Mani <amani(at)accelaero(dot)com<mailto: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 ?

Most likely. I would recommend enabling checkpoint logging to get a better understanding how often checkpoint are occurring, duration, and size in relation to buffer pool. Check for 'checkpoint starting' and 'checkpoint complete' in the PostgreSQL log files after enabling it.

log_checkpoints = on

What is shared_buffers, max_wal_size, and wal_buffers set to?

Why it say "incomplete startup packet" in the log.

This should be benign.