How do database connections work in PDI? I've got a report with a lot of graphs. Each graph connects to the same database. When I run the report, I'm often hit with an error in generating the PDF. The error message said it was caused by: org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections.


This is from running only one report. I'm wondering if I've build the report in such a way that every graph is literally a new connection all hitting the database at the same time. Is there a way for some of the graphs to share a connection? I've tried connection pooling with pgBouncer. The report has now been computing the layout for thirty minutes.

Any help would be awesome!


Thanks