Re: Infinite waitOnLock

We call stop on the postgresql service so "sudo service postgresql stop".
The TCP keepalive settings are all at default but we also tried these
settings :

tcp_keepalives_idle = 30
tcp_keepalives_interval = 30
tcp_keepalives_count = 1


2014-12-04 16:30 GMT+01:00 Kevin Grittner <kgrittn@ymail.com>:

> Leonard Meyer <lmeyer@excilys.com> wrote:
>
> > We're doing an ETL Akka application using PostgreSQL 9.3.5 using
> > driver 9.3-1102-jdbc41. We're currently testing our application
> > resilience by shutting down the database in the middle of our
> > processing.
>
> *Exactly* how are you "shutting down the database"?
>
> What TCP keepalive settings have you set on either end?
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>