Re: Change recovery configuration without restarting standby_node.

From: Emanuel Calvo <emanuel(dot)calvo(at)2ndquadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Change recovery configuration without restarting standby_node.
Date: 2014-10-27 13:15:25
Message-ID: 544E456D.5070607@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


El 27/10/14 a las 09:31, sudalai escibió:
>
> How to change the* recovery configuration *such as *master ip,
> primary_conninfo* without restarting the standby node in postgresql.
>
You need to do a restart of the standby node:

http://www.postgresql.org/docs/9.3/static/recovery-config.html

"They cannot be changed once recovery has begun"

--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Calvo 2014-10-27 13:22:17 Re: some queries on standby preventing replication updates
Previous Message sudalai 2014-10-27 12:31:19 Change recovery configuration without restarting standby_node.