Re: [ADMIN] Turning a streaming standby into a hot-standby

2012-11-08 Thread Fujii Masao
On Fri, Nov 9, 2012 at 2:44 AM, Axel Rau wrote: > > Am 08.11.2012 um 18:16 schrieb Fujii Masao: > >> On Fri, Nov 9, 2012 at 1:13 AM, Axel Rau wrote: >>> Hi dbas, >>> >>> I changed hot_standby to "on" on the standby and learned on restart: >>> "hot standby is not possible because wal_level was not

Re: [ADMIN] Turning a streaming standby into a hot-standby

2012-11-08 Thread Axel Rau
Am 08.11.2012 um 18:16 schrieb Fujii Masao: > On Fri, Nov 9, 2012 at 1:13 AM, Axel Rau wrote: >> Hi dbas, >> >> I changed hot_standby to "on" on the standby and learned on restart: >> "hot standby is not possible because wal_level was not set to >> ""hot_standby"" on the master server" >> Afte

Re: [ADMIN] Turning a streaming standby into a hot-standby

2012-11-08 Thread Fujii Masao
On Fri, Nov 9, 2012 at 1:13 AM, Axel Rau wrote: > Hi dbas, > > I changed hot_standby to "on" on the standby and learned on restart: > "hot standby is not possible because wal_level was not set to ""hot_standby"" > on the master server" > After restarting the master with "wal_level = hot_standby",