Re: Clients disconnect but query still runs
От | Csaba Nagy |
---|---|
Тема | Re: Clients disconnect but query still runs |
Дата | |
Msg-id | 1248953800.24829.54.camel@pcd12478 обсуждение исходный текст |
Ответ на | Re: Clients disconnect but query still runs (Craig Ringer <craig@postnewspapers.com.au>) |
Ответы |
Re: Clients disconnect but query still runs
|
Список | pgsql-general |
On Thu, 2009-07-30 at 13:22 +0200, Craig Ringer wrote: > So, barring network breaks (wifi down / out of range, ethernet cable > fell out, etc etc) how is the OP managing to leave backends running > queries? Hard-resetting the machine? It happened to us when a client box went out of memory and started swapping up to the point it was unaccessible even for console login. The connections of that machine were still live but unusable, as the client box will never get out of that state until hard resetting... which we would promptly do, but the connections on postgres side would still live on. I will probably have to check out now the network connection parameters in the postgres configuration, never had a look at them before... in any case >2 hours mentioned in an earlier post seems a bad default to me. Cheers, Csaba.
В списке pgsql-general по дате отправления: