Postgres Pro
Downloads
Home   >   mailing lists

Removal of $PGDATA/base files that existed before streaming replication (v9.2.4) - Mailing list pgsql-admin

From Dana Rea
Subject Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
Date
Msg-id CANAczPtj+1GV=CQG2TTb4K7tfg3DJ=4u6hkoikiYNSHGn4Y1MA@mail.gmail.com
Whole thread Raw
Responses Re: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)  (Stéphane Schildknecht<stephane.schildknecht@postgres.fr>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Fernando Hevia
Date:
Subject: Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
Next
From: Stéphane Schildknecht
Date:
Subject: Re: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)