Turn off streaming replication - leaving Master running

From: Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Turn off streaming replication - leaving Master running
Date: 2015-06-29 05:42:03
Message-ID: CADqp7UD2mzQxs4fx+yraeT3aqa9pMA0edixMM1hYqRjWRGt+_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to turn off the streaming on my postgresdb (9.2) It is currently
setup to stream from master to a single secondary.

I want to shutdown the secondary and turn it into another master and
connect it to another application for testing - after which i want to
revert it back to a streaming secondary.

Is this possible while not touching the Master DB ? If so what are the
correct steps pls ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-06-29 05:51:02 Re: create index on a field of udt
Previous Message Shujie Shang 2015-06-29 05:31:28 Re: create index on a field of udt