Postgres Pro
Downloads
Home   >   mailing lists

how to PG close session - Mailing list pgsql-admin

From Little, Douglas
Subject how to PG close session
Date
Msg-id 8585BA53443004458E0BAA6134C5A7FB19520849@EGEXCMB01.oww.root.lcl
Whole thread Raw
Responses Re: how to PG close session
List pgsql-admin
Tree view

Hi,

 

We have a number of long running java/jdbc applications that wait for events and then extract data from PG.

During the time the apps are running,   The app is maintaining active connections to PG.

Is there a way that we can close/terminate the pg session so that the connections don’t consume resource unnecessarily.

 

Thanks

 

 

Doug Little

 

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: could not connect to server: Connection refused (0x0000274D/10061)
Next
From: "Kevin Grittner"
Date:
Subject: Re: how to PG close session