replication_timeout not effective

From: Dang Minh Huong <kakalot49(at)gmail(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: replication_timeout not effective
Date: 2013-04-10 04:04:52
Message-ID: 6461930E-86E2-431B-B5C0-84217678BA80@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi,

I'm wondering if this is a bug of PostgreSQL.

PostgreSQL's show that replication_timeout parameter can "Terminate replication connections that are inactive longer than the specified number of milliseconds". But in my environment the sender process is hang up (in several tens of minunites) if i turn off (by power off) Standby PC while pg_basebackup is excuting.

Is this correct?

As my debug, sender process is terminated when recieve SIGPIPE process but it come too slow (about 30minutes after standby PC was down).

I'm not certain but It might hang up in send () from /lib64/libc.so.6

I'm using version 9.1.9 of PostgreSQL.

Thanks,

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2013-04-10 05:05:14 Re: replication_timeout not effective
Previous Message Amit Kapila 2013-04-10 03:48:20 Re: BUG #8050: Need quotes around service exe (imagepath registry key)

Browse pgsql-hackers by date

  From Date Subject
Next Message Rodrigo Barboza 2013-04-10 04:59:25 Re: Unrecognized type error (postgres 9.1.4)
Previous Message Robert Haas 2013-04-10 04:04:17 Re: Reassign variable value in XLogReadRecord