-----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

Reply via email to