On Fri, Nov 9, 2012 at 1:13 AM, Axel Rau <axel.rau@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
