Re: Turn off streaming replication - leaving Master running

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Turn off streaming replication - leaving Master running
Date: 2015-06-29 06:50:34
Message-ID: CAB7nPqTsb363OwuXh2H888KZrjUQ6wx8UusgKjXYLM+A0G8-AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au>
wrote:

> no snapshot available .. i don't mind running basebackup once i've
> finished my test.
>
> So if someone could help with the steps to turn off replication and bring
> secondary up as a standalone db that would be great.
>

How to promote a node: pg_ctl promote or use a trigger_file:
http://www.postgresql.org/docs/devel/static/warm-standby.html#STANDBY-SERVER-OPERATION
Turning temporarily off replication has little meaning if you intend to
bring back a new standby afterwards.
My 2c.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Erskine 2015-06-29 06:58:37 Re: Turn off streaming replication - leaving Master running
Previous Message John R Pierce 2015-06-29 06:45:06 Re: create index on a field of udt