Error when doing too many calls, pq: remaining connection slots are reserved for non-replication superuser connections

[rogerfar]

When running too many queries at the same (I have a large amount of users and databases) a command like terraform destroy will break the provider with the error:

pq: remaining connection slots are reserved for non-replication superuser connections

It might be needed to more efficiently open and close connections when needed, or limit the amount of open connections.