Re: Windows service randomly stops with no indication why

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Windows service randomly stops with no indication why
Дата
Msg-id CANzqJaDXH38K6fL=1EpuZVU6AkS8vUcEZizA5Dp83wLXJGk56A@mail.gmail.com
обсуждение исходный текст
Ответ на Windows service randomly stops with no indication why  (Jay Madren <jay@jaymadren.com>)
Список pgsql-general
On Fri, Mar 8, 2024 at 9:17 AM Jay Madren <jay@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jay Madren
Дата:
Сообщение: Windows service randomly stops with no indication why
Следующее
От: Greg Sabino Mullane
Дата:
Сообщение: Re: Windows service randomly stops with no indication why