From: | Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)au> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Turn off streaming replication - leaving Master running |
Date: | 2015-06-29 06:34:53 |
Message-ID: | CADqp7UA5_a-TUv-vLDuuUbkRUh1D8geu_JLuFctQQwFFZOFpcg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
thanks.
On 29 June 2015 at 15:58, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 6/28/2015 10:52 PM, Michael Paquier wrote:
>
>> Well, yes. It depends on what you want to do then. If this testing
>> really requires to promote the standby then you will need to take a
>> new fresh base backup knowing that you are using 9.2.
>>
>
> if the standby is running on a file system with snapshotting (like zfs),
> and the master is doing WAL archiving, you could, in theory, pause the
> replication and snapshot the slave, do read/write tests on the slave, then
> restore that snapshot and resume replication, pulling from the WAL archive
> til it catches up.
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
*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 06:41:51 | Re: create index on a field of udt |
Previous Message | Shujie Shang | 2015-06-29 06:24:34 | Re: create index on a field of udt |