From: Jerry Sievers <gsievers19@comcast.net>
To: Wells Oliver <wellsoliver@gmail.com>
Cc: gilberto.castillo@etecsa.cu
Cc: pgsql-admin@postgresql.org
Subject: Re: Creating new cluster by copying directory?
Date: Thu, 11 Jul 2013 15:54:19 -0500
Message-ID: <87zjts6cn8.fsf@comcast.net> (raw)
In-Reply-To: <CAOC+FBVXM+d4m_03xsh2MQOR24ejoLHFmw16xA5E883pRsAhng@mail.gmail.com>
References: <CAOC+FBWPBS1_nH4mTcC9qr_c6Rr410d=LR6L9LRLnDDS=zz68A@mail.gmail.com>
<53809.192.168.207.54.1373575311.squirrel@webmail.etecsa.cu>
<CAOC+FBVXM+d4m_03xsh2MQOR24ejoLHFmw16xA5E883pRsAhng@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Wells Oliver <wellsoliver@gmail.com> writes:
> 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?
Yes, provided that you put main in backup mode and then do a PITR when
you bring up this new test instance.
If your main DB is running but absolutely idle, you might get away
just starting it in which case the postmaster will do a regular crash
recovery but I'll presume your source instance 'main' isn't idle.
Study the manual sections relating to backup/PITR.
HTH
> On Thu, Jul 11, 2013 at 1:41 PM, Gilberto Castillo <gilberto.castillo@etecsa.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@gmail.com
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, wellsoliver@gmail.com, gilberto.castillo@etecsa.cu
Subject: Re: Creating new cluster by copying directory?
In-Reply-To: <87zjts6cn8.fsf@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox