From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Windows service randomly stops with no indication why |
Date: | 2024-03-08 14:32:35 |
Message-ID: | CANzqJaDXH38K6fL=1EpuZVU6AkS8vUcEZizA5Dp83wLXJGk56A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Mar 8, 2024 at 9:17 AM Jay Madren <jay(at)jaymadren(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2024-03-08 14:45:20 | Re: Windows service randomly stops with no indication why |
Previous Message | Jay Madren | 2024-03-08 14:17:12 | Windows service randomly stops with no indication why |