Re: Turn off streaming replication - leaving Master running

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(dot)paquier(at)gmail(dot)com> wrote:

>
>
> On Tue, Jun 30, 2015 at 1:39 PM, Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au>
> 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(dot)erskine(at)jds(dot)net(dot)au <andy(dot)erskine(at)jds(dot)net(dot)au>*

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

[image: JDS Signature v1]