On Tue, Jun 30, 2015 at 1:39 PM, Andy Erskine <andy.erskine@xxxxxxxxxx> wrote:
No i don't want a replica.I would like to reconfigure my streaming scenario into two standalone db's i don't want the Master to be effected in anyway and i want it running consistantly .. the secondary i want to reconfigure as a standalone to load a different db and do some testing.
When i've finished testing - i want to reconfigure for streaming again.
Well, in this case:
1) promote your standby
2) Run your tests on it.
3) Recreate a new standby
The documentation online, as well as the PostgreSQL wiki have all the documentation to help you achieve those steps.
Regards,
--
Michael
