I'm running out of connections on a postgresql database. I'm using library(pool) to manage connections at the application level, but multiple apps are running and I'm thus running out of connections. I'm trying to implement connection pooling at the database level (on Digital Ocean).
But I'm also using prepared statements, which requires that the connection to the database include "binary_parameters="yes"".
How do I pass that to the connection string?
The below doesn't work (it produces Error: invalid connection option "binary_parameters"):
Finally, maybe connection pooling, plus libary(pool) in a shiny app, is not the right way to go. The big question is how do I get around the problem of connection refused b/c of exceeding the 22 connection limit on a database hosted at Digitial Ocean?
I'm running out of connections on a postgresql database. I'm using library(pool) to manage connections at the application level, but multiple apps are running and I'm thus running out of connections. I'm trying to implement connection pooling at the database level (on Digital Ocean).
But I'm also using prepared statements, which requires that the connection to the database include "binary_parameters="yes"".
How do I pass that to the connection string?
The below doesn't work (it produces
Error: invalid connection option "binary_parameters"
):Finally, maybe connection pooling, plus libary(pool) in a shiny app, is not the right way to go. The big question is how do I get around the problem of connection refused b/c of exceeding the 22 connection limit on a database hosted at Digitial Ocean?