Thread: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
From
Dana Rea
Date:
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,
--
--
Dana Rea
Infrastructure Team Lead
Informatics Department
Biodiversity Institute of Ontario
University of Guelph
Guelph Ontario Canada N1G2W1
University of Guelph
Guelph Ontario Canada N1G2W1
(519) 824-4120 x52872
Re: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
From
Stéphane Schildknecht
Date:
-----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-----
FW: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
From
Richie Vazquez
Date:
-----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Stéphane Schildknecht Sent: Wednesday, August 28, 2013 10:23 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Removal of $PGDATA/base files that existed before streaming replication (v9.2.4) -----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