Re: Turn off streaming replication - leaving Master running

[Andy Erskine <andy.erskine@xxxxxxxxxx>]

Ok so a question i should have asked at the very beginning ..

If i touch my trigger file - promoting the secondary to a master - will that in anyway effect the master thats already running ?

IE no files on the master will change ?

Then all i'll have to do is shutdown the secondary when i've finished and run the basebackup process again to restore replication (and change recovery.done - conf again.

thanks.

On 30 June 2015 at 15:22, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:

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

--

Andy Erskine

 

JDS Australia
P 1300 780 432 | M 0431919301 | F 03 90124578

E: andy.erskine@jds.net.au

W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001