Re: Windows service randomly stops with no indication why

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
ray(at)rodonnell(dot)ie