On Wed, Feb 9, 2011 at 6:36 AM, mark <dvlh...@gmail.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
