Обсуждение: after failover?
The tutorial here excludes an important issue: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby After the failover is complete, it seems like a restart is required to make the new primary capable of supporting a new hot standby. Can the config values be changed without an interuption of service? I'm using a hotstandby config in 9.0.x. Anything different in this regard in 9.1? Thanks.
On Fri, Oct 14, 2011 at 3:02 PM, Ray Stell <stellr@cns.vt.edu> wrote: > The tutorial here excludes an important issue: > http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby > After the failover is complete, it seems like a restart is required to > make the new primary capable of supporting a new hot standby. Can the > config values be changed without an interuption of service? I'm using > a hotstandby config in 9.0.x. Anything different in this regard in 9.1? > Thanks. There's no reason not to have wal_level = hot_standby on the standby also. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
On Sun, Oct 16, 2011 at 08:21:31PM +0100, Simon Riggs wrote: > On Fri, Oct 14, 2011 at 3:02 PM, Ray Stell <stellr@cns.vt.edu> wrote: > > > The tutorial here excludes an important issue: > > http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby > > After the failover is complete, it seems like a restart is required to > > make the new primary capable of supporting a new hot standby. ?Can the > > config values be changed without an interuption of service? ?I'm using > > a hotstandby config in 9.0.x. ?Anything different in this regard in 9.1? > > Thanks. > > There's no reason not to have wal_level = hot_standby on the standby also. That's helpful, thanks. Seems like a worthy addition to the doc and tutorial.
On Mon, Oct 17, 2011 at 2:44 PM, Ray Stell <stellr@cns.vt.edu> wrote: > On Sun, Oct 16, 2011 at 08:21:31PM +0100, Simon Riggs wrote: >> On Fri, Oct 14, 2011 at 3:02 PM, Ray Stell <stellr@cns.vt.edu> wrote: >> >> > The tutorial here excludes an important issue: >> > http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby >> > After the failover is complete, it seems like a restart is required to >> > make the new primary capable of supporting a new hot standby. ?Can the >> > config values be changed without an interuption of service? ?I'm using >> > a hotstandby config in 9.0.x. ?Anything different in this regard in 9.1? >> > Thanks. >> >> There's no reason not to have wal_level = hot_standby on the standby also. > > That's helpful, thanks. Seems like a worthy addition to the doc and > tutorial. Doc patches welcome. Wiki changes can be made directly. Thanks. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services