Postgres Pro
Downloads
Home   >   mailing lists

Turning a streaming standby into a hot-standby - Mailing list pgsql-admin

From Axel Rau
Subject Turning a streaming standby into a hot-standby
Date
Msg-id 7D14E04E-D605-4996-9329-43686395AD35@chaos1.de
Whole thread Raw
Responses Re: Turning a streaming standby into a hot-standby
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Re: analyze log question on parent/children tables
Next
From: Mike Broers
Date:
Subject: Re: bumping all sequence ids in a schema