-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/29/06 11:18, Tony Heal wrote: > OK, how do you determine the disk size of a database. I have a var partition > that is at 90% capacity and growing, and there are some databases I can > remove, but it would be easier if I knew which DB's were taking up what disk > space.
I don't think you can. However, the postgresql-general list would be helpful. Also, the Postgresql docs are pretty thorough. They *might* point you to system tables that can help you write a script to determine the info you want. If you use v 8.1.x, tablespaces are the way to go. Among other things, they let you put each database (and schema and table and index, if you'd like) in it's own subdirectory. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFRSPXS9HxQb37XmcRAuSRAKCKk6dWpiAc5t8p3EjeeT3HluePOgCdHUcx 0kOWgnrvJEtWPBu8Fbd4MbQ= =CL3T -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
