> 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>
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin