Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VEgdx-0007BB-OU for pgsql-admin@arkaria.postgresql.org; Wed, 28 Aug 2013 14:22:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VEgdw-0003su-4G for pgsql-admin@arkaria.postgresql.org; Wed, 28 Aug 2013 14:22:44 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VEgdv-0003so-8t for pgsql-admin@postgresql.org; Wed, 28 Aug 2013 14:22:43 +0000 Received: from ks392306.kimsufi.com ([176.31.105.177] helo=cathode.atosc.org) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VEgdr-0007Qr-Ay for pgsql-admin@postgresql.org; Wed, 28 Aug 2013 14:22:42 +0000 Received: from [10.0.73.145] (unknown [78.250.200.208]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by cathode.atosc.org (Postfix) with ESMTPSA id BF1F560F12 for ; Wed, 28 Aug 2013 16:23:05 +0200 (CEST) Message-ID: <521E07AA.1070401@postgres.fr> Date: Wed, 28 Aug 2013 16:22:34 +0200 From: =?UTF-8?B?U3TDqXBoYW5lIFNjaGlsZGtuZWNodA==?= User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/20130329 Thunderbird/17.0.5 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4) References: In-Reply-To: X-Enigmail-Version: 1.5.2 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) 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 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Le 28/08/2013 15:50, Dana Rea a écrit : > Dear pgsql-admin, > > I set up streaming replication using the rsync base backup described in > the wiki: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial > > However, before starting replication I had previously loaded some > databases on the "Secondary" server for testing. Folders for those db's > are still in base/ and are consuming a lot of disk space. du reports that > the base on my Secondary is twice as large as on the Primary. > > Do I have safe options for removing this unused data, beyond clearing the > Secondary's $PGDATA folder and re-doing the synchronization? > > Cheers, > Hi, You should try "rsync" with --delete option. Therefore you'll be able to not synchronize what's already on slave, and delete what's not on the master anymore. Regards, - -- Stéphane Schildknecht http://www.Loxodata.com Contact régional PostgreSQL http://bistri.me/sas -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJSHgepAAoJECIy/X6KSrGwOgQIAJLjYTOY1p4M8BfAsM5bgIoA jmzk8D/XfgMhoeXSGH7T4RFWM8g96DnImoustX6+TiqwnzVcQq7YYkGG0jP1D+wF xInVRSs9Ppi9zpygCVGEd4bAi2i/4B6omCqRxAq98kAU53FU296mRhfJqXsZRJGM 3W8iDtphXfWiWcofU1rvnjhnL5SqKXlGqB3237t/PUzefGikanXjJ8s7vZJuozUk 4WxaEtWVLUQ/cwOtFR4nsmLMMvRjG1ZAhnccNfdChk4RVGD00WzFy4dcmzmwEMvi 0KqpAx1bNqQflsdC+3w/hD8VJVToBu6eN+io33nzF5WTh6H7+iC/NQ3sPUdOohU= =zxXY -----END PGP SIGNATURE----- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin