On Mon, Feb 24, 2025 at 3:50 PM Yongye Serkfem <yserk...@gmail.com> wrote:
> > I am having a series of idle connections and unable to delete them with a > single command. Any help in realizing this would be greatly appreciated. > > "deleting" really isn't the word used to describe this, terminate, kill, or disconnect would be better choices. You should be able to just use pg_terminate_backend in a select query to accomplish your goal. https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL Though usually you are better off fixing the problem at the source; or use something like pgbouncer. David J.
