Postgres Pro
Downloads
Home   >   mailing lists

Turn off streaming replication - leaving Master running - Mailing list pgsql-general

From Andy Erskine
Subject Turn off streaming replication - leaving Master running
Date
Msg-id CADqp7UD2mzQxs4fx+yraeT3aqa9pMA0edixMM1hYqRjWRGt+_w@mail.gmail.com
Whole thread Raw
Responses Re: Turn off streaming replication - leaving Master running  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
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 ?

pgsql-general by date:

Previous
From: Shujie Shang
Date:
Subject: Re: create index on a field of udt
Next
From: John R Pierce
Date:
Subject: Re: create index on a field of udt