I have the following directory structure under /var/lib/postgres on my server:
$ sudo find /var/lib/postgres/ -type d /var/lib/postgres/ /var/lib/postgres/data /var/lib/postgres/data/base /var/lib/postgres/data/base/1 /var/lib/postgres/data/base/17141 /var/lib/postgres/data/base/17142 /var/lib/postgres/data/global /var/lib/postgres/data/pg_clog /var/lib/postgres/data/pg_xlog /var/lib/postgres/dumpall /var/lib/postgres/dumpall/7.2 /var/lib/postgres/dumpall/7.4 /var/lib/postgres/dumpall/unknown /var/lib/postgres/preserve /var/lib/postgres/preserve/data.7.2.1-2woody8.save /var/lib/postgres/preserve/data.7.2.1-2woody8.save/base /var/lib/postgres/preserve/data.7.2.1-2woody8.save/base/1 /var/lib/postgres/preserve/data.7.2.1-2woody8.save/base/16555 /var/lib/postgres/preserve/data.7.2.1-2woody8.save/base/16558 /var/lib/postgres/preserve/data.7.2.1-2woody8.save/global /var/lib/postgres/preserve/data.7.2.1-2woody8.save/pg_clog /var/lib/postgres/preserve/data.7.2.1-2woody8.save/pg_xlog The 7.2 and 7,4 directories contain conf files, libraries and binaries that appear like they belong to postgres. The stuff under preserve is obviously a backup from when I upgraded from Woody to Sarge. My question is, how do I get rid of the extra stuff? The dumpall and preserve subdirectories take up more than half of the space in /var/lib/postgres. I have tried searching with Google, but all of the hits talk about upgrading from one version to another of Postgres and none of them ever talk about removing the backed up data. I imagine that it has something to do with the backups being created as part of the Debian-specific package upgrade process. Any suggestions? -Roberto -- Roberto C. Sanchez http://familiasanchez.net/~roberto
pgpNCnlxyrqtH.pgp
Description: PGP signature