Durumdara wrote: >> You can use pg_terminate_backend to kill a database session. >> >> Setting the keepalive options in postgresql.conf can make PostgreSQL >> discover dead connections more quickly. > > The server is licenced, so we can't access the conf file now. > We will report this to the provider.
You cannot use ALTER SYSTEM from SQL either? > For that moment could we set these parameters from clients after the > connection established? > > For example: > > set param bla = nnn? Yes, that should work, e.g.: SET tcp_keepalives_idle = 600; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
