Hmm, is it feasible to create a new cluster by using pg_basebackup, e.g: 1. pg_createcluster 9.1 test 2. pg_basebackup --pgdata=/var/lib/postgresql/9.1/test -h localhost -p 5432 3. pg_ctlcluster 9.1 test start
Would that work? On Thu, Jul 11, 2013 at 1:54 PM, Jerry Sievers <gsiever...@comcast.net>wrote: > Wells Oliver <wellsoli...@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.casti...@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 > > wellsoli...@gmail.com > > > > -- > Jerry Sievers > Postgres DBA/Development Consulting > e: postgres.consult...@comcast.net > p: 312.241.7800 > -- Wells Oliver wellsoli...@gmail.com
