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.