Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UxNnS-0005nL-Nv for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jul 2013 20:49:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UxNnS-0001bO-13 for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jul 2013 20:49:02 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UxNnQ-0001bH-8r for pgsql-admin@postgresql.org; Thu, 11 Jul 2013 20:49:00 +0000 Received: from nm29-vm1.bullet.mail.bf1.yahoo.com ([98.139.213.144]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UxNnI-0007ux-4w for pgsql-admin@postgresql.org; Thu, 11 Jul 2013 20:48:59 +0000 Received: from [66.196.81.172] by nm29.bullet.mail.bf1.yahoo.com with NNFMP; 11 Jul 2013 20:48:51 -0000 Received: from [98.139.212.225] by tm18.bullet.mail.bf1.yahoo.com with NNFMP; 11 Jul 2013 20:48:51 -0000 Received: from [127.0.0.1] by omp1034.mail.bf1.yahoo.com with NNFMP; 11 Jul 2013 20:48:50 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 995467.54764.bm@omp1034.mail.bf1.yahoo.com Received: (qmail 12908 invoked by uid 60001); 11 Jul 2013 20:48:50 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1373575730; bh=b6bVheW+Vb41UHiIXcfUzdAHauTl7y5xaJFtnYaWXHg=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=u42nuor4xsymcFLY9EB6PWp/JwreQRhtOIryf3OkR8XGwNKgO/irwyztLfYaNPaJKmLb/MuxolMGUvhYXabcX/LF5Wr0N4fQb7m2AEMpzj60nyaQ+TWudzNLuD522ISKXp+IGq+skRrcUKQBYLU+LBhVFRPxArpu363X+u+SSok= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=PWWJUPHhVccwAHfscWhp0tMZSP7B+TB0hA5QpCmDCOrewcOBfynhz5OhAg9Wqtbat9q2pvgOeIPl+lobTBUsK8rxYESdp36foxCzEYBINnhzpHjpfDQvxSuQLuD0/GjroBjtkEwedI3L8bFX0NEtj/Nbp6kfNfzxEjDUgMS5qyo= ; X-YMail-OSG: ohoWNHwVM1nBgKdVXxOH1HnqWTvALeMiompxPr_pj245c8c bEgllJiKqDOUPS1a.1TMEi4pGOmmZQkxt.hUMNWYKkGWjFGl67WqB4JTim4k iBJEPrNGNieNumFqvckKFq_CgGdvfXgc9cx86u4BZSeNpc_X8YeWjaLhL08q UWNzNMQUhrEBEtAepCMV9jzvXiesPwPG_6VNMMMtMFqb1YUB9blexjj2GOgj SIxHLx5lk3pwLjJwJhB9nP4.utMxXmK6RWjoVuWS.ojf6mX78F8CcSvB1sNg Osoiw6uMIUR0_S045ZRxqrcmHMWqu0sMy8ASuLRv4Rc48pF_iUrv.N_sdIHe kuUG1ZfMbv1wLytcKK2XusVKAdaPWMPEqYmI2ytl5XKrSyVE_yDR68ElB7cZ 68zIX41O_dQjECEz.t2UN22HCZnE5wwuZ2hutVsOQwIVWCaPL6spc6PGI7ar vvK_.tkcb6ofMdvrEvvi6vlHnqMQTNVG8YAf51bBCID0TdLRbpihxPbZjcnL 0D4WWALzCxLaFmg_NsdmQl5vDTlssr286pDuh5zuMX_4mAqfsXVLrko.YLcp XyMmRUoHGArU.VOT72h1J6M09JPWkRIXirrfIVpoPxY2bhBkOufL25xXzZkj gVwCn7kwHDDcmqxaHHxHbtPqR5QYBsuP27V.TA_kgrZaW1IblMnSRlsWYQSU 3JLhGsGvJQxCrxl6nJ73C4ra6PsipSvlOKmZKLi3xLsH36e5OJeDC Received: from [76.255.18.237] by web162904.mail.bf1.yahoo.com via HTTP; Thu, 11 Jul 2013 13:48:50 PDT X-Rocket-MIMEInfo: 002.001, V2VsbHMgT2xpdmVyIDx3ZWxsc29saXZlckBnbWFpbC5jb20.IHdyb3RlOgoKPiBTbyBpdCdzIHNhZmUgdG8gY29weSB0aGUgZmlsZXMgaW4gL3Zhci9saWIvcG9zdGdyZXNxbC85LjEvbWFpbiB0bwo.IC92YXIvbGliL3Bvc3RncmVzcWwvOS4xL3Rlc3Qgd2hpbGUgbWFpbiBpcyBydW5uaW5nPwoKQXMgbG9uZyBhcyB5b3UgY29weSB0aGUgd2hvbGUgJFBHREFUQSB0cmVlIHdoaWxlIHRoZSBzb3VyY2UgY2x1c3RlcgppcyBzdG9wcGVkLCBvciB1c2UgUElUUiByZWNvdmVyeSB0ZWNobmlxdWVzOgoKaHR0cDovL3cBMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 References: <53809.192.168.207.54.1373575311.squirrel@webmail.etecsa.cu> Message-ID: <1373575730.11179.YahooMailNeo@web162904.mail.bf1.yahoo.com> Date: Thu, 11 Jul 2013 13:48:50 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Creating new cluster by copying directory? To: Wells Oliver , "gilberto.castillo@etecsa.cu" Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Wells Oliver wrote: > 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? As long as you copy the whole $PGDATA tree while the source cluster is stopped, or use PITR recovery techniques: http://www.postgresql.org/docs/9.2/interactive/backup.html Of course, the machines must be of the same architecture. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin