Re: [HACKERS] Proposal to add connection request Wait-time in PSQL client.

2013-05-20 Thread amul sul
    in a way, we client terminal wont hangup by throwing  *The connection to  the server was lost. Attempting reset: Failed. !* The thing is that this just should not be a routine occurrence. It's a minor irritation to me when debugging sometimes, but it's not something that you should be

Re: [HACKERS] Proposal to add connection request Wait-time in PSQL client.

2013-05-18 Thread Craig Ringer
On 05/17/2013 08:22 AM, amul sul wrote: Hello, I have observed the following same situation in PG 9.3beta1 Multiple PSQL clients are connected to server, some of them running transaction and some of them are idle state. When one of the backend is killed or crashed (using kill -9

Re: [HACKERS] Proposal to add connection request Wait-time in PSQL client.

2013-05-18 Thread amul sul
It isn't clear to me why this needs to be tackled in psql or the other clients. This case only for the client PSQL, who has running transaction,yet not has been finished  and suddenly some other backend crashed or killed, then server restarted in recovery mode. Then this client immediately

Re: [HACKERS] Proposal to add connection request Wait-time in PSQL client.

2013-05-18 Thread Craig Ringer
On 05/19/2013 11:41 AM, amul sul wrote: in a way, we client terminal wont hangup by throwing *The connection to the server was lost. Attempting reset: Failed. !* The thing is that this just should not be a routine occurrence. It's a minor irritation to me when debugging sometimes, but it's

[HACKERS] Proposal to add connection request Wait-time in PSQL client.

2013-05-16 Thread amul sul
Hello, I have observed the following same situation in PG 9.3beta1 Multiple PSQL clients are connected to server, some of them running   transaction and some of them are idle state.   When one of the backend is killed or crashed (using kill -9 backend-pid). The connection reset attempt from the