RE: postgresql database file names
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:roberto@connexer.com]
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
Reply to: