On Mon, Oct 17, 2011 at 2:44 PM, Ray Stell <stellr@xxxxxxxxxx> 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@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
