From: | Wells Oliver <wellsoliver(at)gmail(dot)com> |
---|---|
To: | gilberto(dot)castillo(at)etecsa(dot)cu |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Creating new cluster by copying directory? |
Date: | 2013-07-11 20:42:01 |
Message-ID: | CAOC+FBVXM+d4m_03xsh2MQOR24ejoLHFmw16xA5E883pRsAhng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
So it's safe to copy the files in /var/lib/postgresql/9.1/main to
/var/lib/postgresql/9.1/test while main is running?
On Thu, Jul 11, 2013 at 1:41 PM, Gilberto Castillo <
gilberto(dot)castillo(at)etecsa(dot)cu> wrote:
>
>
> > All: it would take ~4 hours to pg_restore a backup. I want to quickly
> > create a duplicate cluster (for testing). My idea:
> >
> > 1. pg_ctlcreatecluster 9.1 test
> > 2. rm /var/lib/postgresql/9.1/test/*
> > 2. cp /var/lib/postgresql/9.1/main /var/lib/postgresql/9.1/test
> > 3. pg_ctlcluster 9.1 test start
> >
> > Is this viable? If not, is there another way to create a duplicate
> cluster
> > in a timely fashion?
>
> Test Repmgr works with the same philosophy. ;-)
>
>
> Saludos,
> Gilberto Castillo
> La Habana, Cuba
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>
>
--
Wells Oliver
wellsoliver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-07-11 20:48:50 | Re: Creating new cluster by copying directory? |
Previous Message | Gilberto Castillo | 2013-07-11 20:41:51 | Re: Creating new cluster by copying directory? |