Re: Turning a streaming standby into a hot-standby

On Fri, Nov 9, 2012 at 1:13 AM, Axel Rau <axel(dot)rau(at)chaos1(dot)de> 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",
> I'm still getting the same error message on the standby.
> This is 9.1.2.
>
> What am I doing wrong?

After setting wal_level to hot_standby in the master, you need to take
a fresh base backup from the master onto the standby, and start the
standby from that backup.

The standby with hot_standby=on needs the backup which was backed
up from the master with wal_level=hot_standby.

Regards,

--
Fujii Masao