On 08/03/2024 14:17, Jay Madren 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?
I haven't used Windows in a very long time, but from (dim and distant)
memory PostgreSQL on Windows maintains its own log files, separate to
the Windows event log - you may find more clues there.
Ray.
--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie