| 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-28 03:31:39 |
| Message-ID: | 3EC70D03-0CAF-4D49-A70E-B6E4953C8962@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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pavan95 | 2018-08-28 05:48:01 | Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication? |
| Previous Message | Mark Kirkwood | 2018-08-27 22:18:11 | Re: Space Related Errors in Postgres 10.4 Logical Replication |