[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Postgres question



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

Attachment: pgpXQDaau4qfY.pgp
Description: PGP signature


Reply to: