Anyone here successfully using PGBouncer on their Digital Ocean Postgres Database? (Strapi V3)

[Dominik]

I am actually still dealing with this knex connection timeout issue with my Strapi v3 instance which causes Strapi to restart occasionally. I really want to avoid this in the future but have not found a working solution yet.

Strapi Postgres Connection Pool breaks connection

So guys here is some update from my deployment setup. I had huge issues on render.com with my setup. I got the knex issue, after some idle time the server lost connection to the database and needed to reboot, … So I increased database and node ressources to very high specs. Without any improvement. So I switched to digitalocean app platform to check if this an issue of render. (Setup is as easy as with render) … Well, yes, it is an issue with render… (At least for me) I am using the followin…

Now my last straw would be to use Digital Ocean’s built-in interface to create a PGBouncer and connect my Strapi instance to the new bouncer.

Theoretically this should do the job but I was wondering if there is anything that might conflict with Strapi’s built-in knex pooling system?