Re: Surviving connections after internet problem

Поиск
Список
Период
Сортировка
От Durumdara
Тема Re: Surviving connections after internet problem
Дата
Msg-id CAEcMXhmEQZ-GTS2f_zP82sT+1kOD4P1ZVFtUC8KTXbk4uRm=kg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Surviving connections after internet problem  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: Surviving connections after internet problem
Список pgsql-general
Дерево обсуждения
Dear Laurenz!


2016-11-07 16:06 GMT+01:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
Durumdara wrote:
> Linux server, 9.4 PG, Windows clients far-far away.
> May we must limit these parameters in clients after the starting of the connection?

Don't bother about the clients, just see that the backends go away on the server.

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.

For that moment could we set these parameters from clients after the connection established?

For example:

set param bla = nnn?

Thank you!

Regards
   dd


В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Linux equivalent library for "postgres.lib" from Windows
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Linux equivalent library for "postgres.lib" from Windows