Sample Header Ad - 728x90

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

1 vote
0 answers
3460 views
I've run into the following problem. From time to time, my app receives remaining connection slots are reserved for non-replication superuser connections from postgres. It lasts for quite noticeable periods of time, from several seconds to couple of minutes. I've checked pg_stat_activity at this very period, and it showed about five application backend connections, several pgAdmin connections, and some postgres-specific processes like replication, autovaccuum, wal-writing, etc -- about 20 processes in total, nothing peculiar. Then I checked SHOW max_connections; -- it was still 200. I've no pooling, nothing except just postgres and a backend application. How come?
Asked by Vadim Samokhin (635 rep)
Aug 10, 2022, 02:54 PM
Last activity: Aug 10, 2022, 03:08 PM