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.

Improve this question
8
  • Any Anti-Virus software active?
    – user1822
    Jan 12, 2022 at 21:03
  • Examine the PostgreSQL log for more information.
    – Laurenz Albe
    Jan 13, 2022 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).
    – StillLearnin
    Jan 13, 2022 at 11:58
  • @LaurenzAlbe, I updated the question to indicate that the log shows what I already posted and nothing else.
    – StillLearnin
    Jan 13, 2022 at 11:58
  • 1
    If that hasn't been done yet, you should exclude the Postgres binaries and data directory from the AV.
    – user1822
    Jan 13, 2022 at 12:12

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.