Turning a streaming standby into a hot-standby

From: Axel Rau <axel(dot)rau(at)chaos1(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Turning a streaming standby into a hot-standby
Date: 2012-11-08 16:13:26
Message-ID: 7D14E04E-D605-4996-9329-43686395AD35@chaos1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Axel
---
PGP-Key:29E99DD6 ☀ +49 151 2300 9283 ☀ computing @ chaos claudius

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Broers 2012-11-08 16:43:59 Re: bumping all sequence ids in a schema
Previous Message Rural Hunter 2012-11-08 15:25:00 Re: analyze log question on parent/children tables