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
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 |