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