pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRemoval of $PGDATA/base files that existed before streaming replication (v9.2.4)
3+ messages / 3 participants
[nested] [flat]
* Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
@ 2013-08-28 13:50 Dana Rea <drea@boldsystems.org>
0 siblings, 1 reply; 3+ messages in thread
From: Dana Rea @ 2013-08-28 13:50 UTC (permalink / raw)
To: pgsql-admin
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
(519) 824-4120 x52872
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
@ 2013-08-28 14:22 Stéphane Schildknecht <stephane.schildknecht@postgres.fr>
parent: Dana Rea <drea@boldsystems.org>
0 siblings, 1 reply; 3+ messages in thread
From: Stéphane Schildknecht @ 2013-08-28 14:22 UTC (permalink / raw)
To: pgsql-admin
-----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
^ permalink raw reply [nested|flat] 3+ messages in thread
* FW: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
@ 2013-08-29 19:18 Richie Vazquez <rvazquez@carpathia.com>
parent: Stéphane Schildknecht <stephane.schildknecht@postgres.fr>
0 siblings, 0 replies; 3+ messages in thread
From: Richie Vazquez @ 2013-08-29 19:18 UTC (permalink / raw)
To: pgsql-admin
-----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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-08-29 19:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-08-28 13:50 Removal of $PGDATA/base files that existed before streaming replication (v9.2.4) Dana Rea <drea@boldsystems.org>
2013-08-28 14:22 ` Stéphane Schildknecht <stephane.schildknecht@postgres.fr>
2013-08-29 19:18 ` Richie Vazquez <rvazquez@carpathia.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox