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.
Tony -----Original Message----- From: Roberto C. Sanchez [mailto:[EMAIL PROTECTED] Sent: Sunday, October 29, 2006 10:14 AM To: debian-user@lists.debian.org Subject: Re: postgresql database file names On Sun, Oct 29, 2006 at 09:49:34AM -0500, Tony Heal wrote: > I am trying to determine how to correlate the file system file names to a > database in /var/lib/postgres/data/base with the database names used in > postgresql > > > > The file system names are: > > > > drwx------ 2 postgres postgres 4096 Oct 29 08:41 1 > > drwx------ 2 postgres postgres 4096 Oct 24 2005 17141 > > drwx------ 3 postgres postgres 16384 Oct 29 07:00 19333 > > drwx------ 3 postgres postgres 20480 Oct 29 07:03 3245791 > > drwx------ 3 postgres postgres 24576 Oct 29 06:03 4859886 > > drwx------ 3 postgres postgres 4096 Oct 29 07:01 6983994 > > > > but the database names are in alpha characters, such as template0, template1 > etc. > > > > Is there a way to determine which directory goes to which database? > > No. Even if there were a way, why would you want to? Regards, -Roberto -- Roberto C. Sanchez http://people.connexer.com/~roberto http://www.connexer.com -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
