On Wed, Feb 9, 2011 at 6:36 AM, mark <dvlhntr(at)gmail(dot)com> wrote:
> this is the recovery.conf file, see any problems with it? maybe I
> didn't do some syntax right right ?
>
> [postgres@<redacted> data9.0]$ cat recovery.conf
> standby_mode = 'on'
> primary_conninfo = 'host=<redacted> port=5432 user=postgres
> keepalives_idle=30 keepalives_interval=30 keepalives_count=30'
This setting would lead TCP keepalive to take about 930 seconds
(= 30 + 30 * 30) to detect the network outage. If you want to stop
replication as soon as the outage happens, you need to decrease
the keepalive setting values.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center