Postgres Pro
Downloads
Home   >   mailing lists

How to automatically delete idle client connections? - Mailing list pgsql-general

From Yu Watanabe
Subject How to automatically delete idle client connections?
Date
Msg-id CALKrq=k_QWHBWtDwmE-95mKC8FNX9wOz=1zJMRVwVeLhkRRLGg@mail.gmail.com
Whole thread Raw
Responses Re: How to automatically delete idle client connections?  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
Tree view
Dear community.

I would like to ask a question regarding the below error occurred when using psql client.
My environment is postgresql 12.3 docker container.
https://hub.docker.com/layers/postgres/library/postgres/12.3/images/sha256-23839ca029051ca19072dc7f40b252ae8cbcd7ef632f7b8e2da09ba3abc60214?context=explore

###
psql: error: could not connect to server: FATAL remaining connection slots are reserved for non-replication superuser connections
###

It seems that this is caused by unused psql client sessions. Which was caused by closing the terminal without exiting the psql session correctly.

###
postgres=# select usename,state,client_port from pg_stat_activity;
 usename  | state  | client_port
----------+--------+-------------
          |        |
 postgres |        |
 catseye  | idle   |          -1
 catseye  | idle   |       36718
 catseye  | idle   |          -1
 catseye  | idle   |       52960
 catseye  | idle   |       40854
...
###

I have tried setting  idle_in_transaction_session_timeout   , however, this does not delete idle sessions.

Would there be any expiry settings to delete client idle sessions automatically ?

My apology if this question was asked before but I appreciate it if someone gives me advice.

Best Regards,
Yu Watanabe

--
Yu Watanabe

linkedin: www.linkedin.com/in/yuwatanabe1/
twitter:   twitter.com/yuwtennis
   

pgsql-general by date:

Previous
From: Avi Weinberg
Date:
Subject: Is it Possible to Rename Replication Slot + Can Publisher be Paused
Next
From: David Rowley
Date:
Subject: Re: How to automatically delete idle client connections?