Re: postgresql database file names
-----BEGIN PGP SIGNED MESSAGE-----
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
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)
-----END PGP SIGNATURE-----