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.
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-bugs by date
|Next:||From: mark||Date: 2011-02-09 00:23:16|
|Subject: Re: BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.|
|Previous:||From: Tom Lane||Date: 2011-02-08 22:49:06|
|Subject: Re: BUG #5872: Function call in SQL function executed only once |