Re: Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again

2021-07-22 Thread Julien Rouhaud
On Thu, Jul 22, 2021 at 09:21:56AM -0500, Ron wrote: > On 7/22/21 4:52 AM, Beat Hoedl wrote: > [snip] > > BTW: There is no virus scanner on the postgres folder and it's a > > productive system, I cant just update. > > > > There's *always* a maintenance window, even if it's just once a year on > C

Re: Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again

2021-07-22 Thread Ron
On 7/22/21 4:52 AM, Beat Hoedl wrote: [snip] BTW: There is no virus scanner on the postgres folder and it's a productive system, I cant just update. There's *always* a maintenance window, even if it's just once a year on Christmas.  Or are you saying that Windows isn't being patched either?

Re: Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again

2021-07-22 Thread Thomas Kellerer
Beat Hoedl schrieb am 22.07.2021 um 11:52: > BTW: There is no virus scanner on the postgres folder and it's a productive > system, I cant just update. Quote from the Postgres homepage https://www.postgresql.org/support/versioning/ > For minor releases, the community considers not upgrading to

Re: Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again

2021-07-22 Thread Julien Rouhaud
On Thu, Jul 22, 2021 at 11:52:55AM +0200, Beat Hoedl wrote: > > Have a bunch of processes connected to Postgres (10.0) [...] > > So the problem leaves me puzzled. > Would be great if somebody has some ideas how to continue investigation. The first thing you need to do is to update to 10.17 and g

Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again

2021-07-22 Thread Beat Hoedl
Hi Have a bunch of processes connected to Postgres (10.0) on windows server 2016. The software was running without problems for at least a year. Each process is doing different actions. Every about 5-10 days a postgres.exe running for one of the application processes crashes, tears down ev