Remaining connection slots are reserved

Error Message Text(s)

Destination does not have sufficient resources. Encountered error: FATAL: remaining connection slots are reserved for non-replication superuser connections

Error Summary

This error may occur intermittently while loading data to the PostgreSQL Destination.

Potential Causes

The PostgreSQL server has a connection limit set on it. Within these connections, Database Administrators (non-replication superusers) have reserved slots. When numerous Pipelines or tables within a Pipeline are loading data to the Destination, it can lead to a spike in concurrent connections to the server. As a result, the server exhausts its available connection slots for replication, and Hevo fails to replicate data.

Suggested Action(s)

• Change the value of max_connection to increase the connection limit on the server. Read max_connections for steps to do this.

• Increase the value of shared_buffers to release the connections faster. Read shared_buffers for steps to do this.