Re: postgresql database file names
-----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-----
Reply to: