Windows service randomly stops with no indication why

From: Jay Madren <jay(at)jaymadren(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Windows service randomly stops with no indication why
Date: 2024-03-08 14:17:12
Message-ID: CANYmBTZ_RzNzVU-WUyM94d_fS-YxtFnqbtSjqbVi0aeufRWkpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,
Jay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-03-08 14:32:35 Re: Windows service randomly stops with no indication why
Previous Message Greg Sabino Mullane 2024-03-08 14:09:28 Re: update to 16.2