On 2019-04-17 18:41:57 +0200, Francisco Olarte wrote:
> On Wed, Apr 17, 2019 at 4:49 PM Ajay Pratap
> wrote:
> > Correction: I meant when my java application dies postgres should break all
> > the connections that were associated with that peer.
>
> And how is the server supposed to detect that
Ajay Pratap writes:
> Enabling system wise timeouts can impact my whole setup including my web
> app, thats why it is hard for me to configure them.
Uh ... who said anything about system-wide timeouts?
The normal way to set this up is to configure the tcp_keepalives_xxx
PG parameters, which will
Maybe postgresql (application) layer ping pong.
Enabling system wise timeouts can impact my whole setup including my web
app, thats why it is hard for me to configure them.
On Wed, Apr 17, 2019, 22:12 Francisco Olarte wrote:
> On Wed, Apr 17, 2019 at 4:49 PM Ajay Pratap
> wrote:
> > Correction
Francisco Olarte writes:
> On Wed, Apr 17, 2019 at 4:49 PM Ajay Pratap
> wrote:
>> Correction: I meant when my java application dies postgres should break all
>> the connections that were associated with that peer.
> And how is the server supposed to detect that without keepalives? TCP
> is de
On Wed, Apr 17, 2019 at 4:49 PM Ajay Pratap wrote:
> Correction: I meant when my java application dies postgres should break all
> the connections that were associated with that peer.
And how is the server supposed to detect that without keepalives? TCP
is dessigned to survice for extended perio
Correction: I meant when my java application dies postgres should break all
the connections that were associated with that peer.
On Wed, Apr 17, 2019, 19:59 Adrian Klaver wrote:
> On 4/17/19 5:39 AM, Ajay Pratap wrote:
> > Hello there,
> > I am using PostgreSQL 10.7 as the database, and have Ja
Adrian Klaver writes:
> On 4/17/19 5:39 AM, Ajay Pratap wrote:
>> I am using PostgreSQL 10.7 as the database, and have Java web app. My
>> app takes a lock on the database using the following command whenever my
>> server is starting.
>> /select /pg_try_advisory_lock/(100)/
>> To make sure only
On 4/17/19 5:39 AM, Ajay Pratap wrote:
Hello there,
I am using PostgreSQL 10.7 as the database, and have Java web app. My
app takes a lock on the database using the following command whenever my
server is starting.
/select /pg_try_advisory_lock/(100)/
To make sure only one instance of the App
