Re: Regarding connection drops for every few minutes

Поиск
Список
Период
Сортировка
От Durgamahesh Manne
Тема Re: Regarding connection drops for every few minutes
Дата
Msg-id CAJCZkoLqagGzCS38yAesEr=rfVD2Bq-D3os-p4rAn_quq1SP3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regarding connection drops for every few minutes  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Regarding connection drops for every few minutes  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Hi Sir  

As per above discussion.....GOOD response from PostgreSQL 

i am very happy to work on PostgreSQL.Super fast response only from postgres team regarding i asked any question related to postgres 

regards
mahesh

On Fri, Mar 11, 2016 at 3:28 PM, John R Pierce <pierce@hogranch.com> wrote:
On 3/11/2016 1:50 AM, Durgamahesh Manne wrote:
 Thanks for quick response .as per above conversation. for which parameter i can comment to resolve the  issue & please specify the value of parameter sir

LOG:  could not receive data from client: Connection reset by peer


your client is disconnecting without closing, thats all that error says, it doesn't say why this is happening, and without knowing why, there's no way to suggest a fix.      

I suppose you could try setting tcp_keepalives_idle, if your connections are staying idle for a long time and your OS doesn't default to using tcp_keepalive, this could help.  

I have no idea what a suitable value is, you didn't specify an operating system, a postgres version, what API your client is using, or if this is a localhost vs a LAN vs an internet connection, or really much of anything else..



btw, please reply to the list,  not to me privately, thank you.



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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Regarding connection drops for every few minutes
Следующее
От: Pierre Chevalier Géologue
Дата:
Сообщение: Re: recovering database from a linux file system