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