Skip site navigation (1) Skip section navigation (2)

Re: BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: mark <dvlhntr(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.
Date: 2011-02-08 22:59:45
Message-ID: AANLkTinuMnkXNmZ3+hmnMNSCAq1s=03QHTWPs_PMSUar@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: markDate: 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 LaneDate: 2011-02-08 22:49:06
Subject: Re: BUG #5872: Function call in SQL function executed only once

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group