On Sat, May 11, 2013 at 7:56 AM, Moshe Jacobson <mo...@neadwerx.com> wrote:
> I have a master database cluster on one server, and it is configured to > ship logs via scp to an archive directory on my slave server. The slave > server is configured for streaming replication, and also is configured to > delete the archived xlogs when they are no longer needed (using > pg_archivecleanup). > > I have a third machine on which I'd like to get another master cluster > running, and I'd like it to start with a copy of my current master. I'd > cannot restart my master, and would prefer not to restart my slave either. > > Given my xlog archive configuration, Is there a way to clone my master > cluster to another machine, including all of the necessary xlogs, without > bringing down the original master or slave? > I'd probably use "pg_basebackup --xlog-method=stream ..." Or temporarily disable pg_archivecleanup. Cheers, Jeff
