From: | Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Turn off streaming replication - leaving Master running |
Date: | 2015-06-29 06:58:37 |
Message-ID: | CADqp7UApEHxvH4u7EPup+wMWK9N4JONhutSo_-+sqnWx2iBo9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If i touch my trigger file and promote my secondary to a master - what
effect will that have on the Master - will i need to make any changes on
that side ? Will it still try and stream data across to the promoted
secondary and just fill up the log files with error messages ?
On 29 June 2015 at 16:50, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
>
>
> On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au>
> wrote:
>
>> no snapshot available .. i don't mind running basebackup once i've
>> finished my test.
>>
>> So if someone could help with the steps to turn off replication and bring
>> secondary up as a standalone db that would be great.
>>
>
> How to promote a node: pg_ctl promote or use a trigger_file:
>
> http://www.postgresql.org/docs/devel/static/warm-standby.html#STANDBY-SERVER-OPERATION
> Turning temporarily off replication has little meaning if you intend to
> bring back a new standby afterwards.
> My 2c.
> --
> 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]
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2015-06-29 07:06:45 | Re: Turn off streaming replication - leaving Master running |
Previous Message | Michael Paquier | 2015-06-29 06:50:34 | Re: Turn off streaming replication - leaving Master running |