On Fri, Nov 9, 2012 at 1:13 AM, Axel Rau <axel.rau@chaos1.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