1

Scenario:

  • Customer’s system
  • VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors)
  • PostgreSQL starts and runs fine for 5 minutes - 2 hours
  • Postgres stops accepting new connections but existing connections continue to function.
  • Postgres log shows worker took too long to start; canceled and nothing else.
  • Windows Task Manager shows multiple Postgres processes (like usual) with a single Postgres process suspended (Not normal)
  • Trying to stop the Postgres service just hangs for a while unless you “end task” on the suspended process.

I've been googling for several hours and am not finding anything.

8
  • Any Anti-Virus software active? Jan 12 at 21:03
  • Examine the PostgreSQL log for more information. Jan 13 at 7:41
  • @a_horse_with_no_name, yes, AV is active though I don't have a connection to the server at the moment to check what it is for sure. Malware Bytes (I think). Jan 13 at 11:58
  • @LaurenzAlbe, I updated the question to indicate that the log shows what I already posted and nothing else. Jan 13 at 11:58
  • 1
    If that hasn't been done yet, you should exclude the Postgres binaries and data directory from the AV. Jan 13 at 12:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.