How to clone a running master cluster?

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to clone a running master cluster?
Date: 2013-05-11 14:56:17
Message-ID: CAJ4CxLk_rJpomuv5bRUB70_eoBLxaNg-OxZaj0Rf7r_k6=gDYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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? Step-by-step instructions would
be much appreciated.

Thank you!

--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2013-05-11 15:27:20 Re: How to clone a running master cluster?
Previous Message Joshua D. Drake 2013-05-11 14:27:30 Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID