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 ?