Re: Database Connectivity Issue with DB Lookup

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Database Connectivity Issue with DB Lookup
Date: 2018-08-27 19:14:19
Message-ID: 978B8866-4065-4C63-B138-AA60501B5833@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Aug 27, 2018, at 1:33 AM, Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com> wrote:
>
> ...issue is that database table keep increasing connections to the database...

You need to figure out why your client always opens new connections and never closes them, then fix that bug. Until then as a workaround you could change that client to exit after each update, or set up a periodic task to kill it.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Cross 2018-08-27 22:05:18 Re: FW: Setting up SSL for postgre
Previous Message Pavan Teja 2018-08-27 18:58:04 Re: Space Related Errors in Postgres 10.4 Logical Replication