Re: Windows service randomly stops with no indication why

2024-03-08 Thread Jay Madren
> What is log_min_messages set to? Increasing it might shed some light. It is not set (commented out). I assume the default is "warning". I will set it to "info" and see if that reveals anything. > Then check the recovery tab and see what it is supposed to do on failures - you are probably at the

Re: Windows service randomly stops with no indication why

2024-03-08 Thread Adrian Klaver
On 3/8/24 06: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 sta

Re: Windows service randomly stops with no indication why

2024-03-08 Thread Ray O'Donnell
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

Re: Windows service randomly stops with no indication why

2024-03-08 Thread Greg Sabino Mullane
Go to "Services", find Postgres, and try a manual restart, see what happens. Then check the recovery tab and see what it is supposed to do on failures - you are probably at the "Do nothing" count limit, hence the no auto restart. If you can manually duplicate the failure to restart, try increasing

Re: Windows service randomly stops with no indication why

2024-03-08 Thread Ron Johnson
On Fri, Mar 8, 2024 at 9:17 AM 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 th