Forum Discussion

wwilbur's avatar
wwilbur
Occasional Contributor
3 years ago

ERROR: org.postgresql.util.PSQLException: FATAL: too many connections

I have closed all connections to the Postgresql database, closed all apps connecting to it, rebooted my computer and still get the above message. This has happened many times for the Postgresql datab...
  • wwilbur's avatar
    wwilbur
    3 years ago
    I went ahead and used another Postgresql database that does not contain PCI information. It worked

    Sincerely,

    Bill Wilbur
    Quality Assurance Analyst
    Information Technology
    O'Reilly Auto Parts
    (417) 862-2674 ext. 1603

    The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
wwilbur's avatar
wwilbur
Occasional Contributor

I tried this but it did not work, thank you for replying

richie's avatar
richie
Community Hero
3 years ago
Hey wwilbur,

The info on the stackoverflow page (the query) should work as the table holds a list of all the connections. Can you clarify exactly what you did and what occurred when you tried? Cos killing that pid works.

Ive re-read your description again and im guessing that keeping active connections in the pool is an issue with postgresql, so theres not much you can do from the other end of things (ReadyAPI) to resolve. This is NOT an issue with ReadyAPI, so the resolution at best is gonna be running a query or a kill command in the OS or something similar. This issue would occur whatever application was hitting the database. Thats where you need to resolve the issue, im thinking

Cheers

Rich
  • wwilbur's avatar
    wwilbur
    Occasional Contributor
    3 years ago
    I went ahead and used another Postgresql database that does not contain PCI information. It worked

    Sincerely,

    Bill Wilbur
    Quality Assurance Analyst
    Information Technology
    O'Reilly Auto Parts
    (417) 862-2674 ext. 1603

    The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
    • sonya_m's avatar
      sonya_m
      SmartBear Alumni (Retired)
      3 years ago

      Thank you for helping, Rich!

       

      Hi wwilbur, thanks a lot for sharing your solution.