On Fri, Mar 8, 2024 at 9:17 AM Jay Madren <j...@jaymadren.com> wrote:
> Running PostgreSQL 15.6 on Windows Server 2022. The database service > randomly just stops and the Windows Service auto-restart options don't kick > in. The stop is unexpected (not a controlled shut down) because after > restarting the service the postgresql log states that the database system > was interrupted, not properly shut down, and automatic recovery in > progress. There's nothing to indicate exactly when it went down, other than > the timestamp of the last log entry before restarting it. > > There's also nothing I could find in the Windows Event Logs other than > when the service is started each time. > > This is occurring at random times, day or night, around 0 to 2 times each > day. > > Any clue as to what's happening or how to investigate this further? > What is log_min_messages set to? Increasing it might shed some light.
