Remaining connection slots are reserved

Last updated on Apr 05, 2024
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)

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Apr-08-2024 NA New document.

Tell us what went wrong