On Mon, Oct 30, 2006 at 12:34:36AM -0500, Tony Heal wrote:
> For those who care. Here is how you determine the disk space used for each
> postgresql db.
>
Neat. Thanks for the info.
Regards,
-Roberto
--
Roberto C. Sanchez
http://people.connexer.com/~roberto
http://www.connexer.com
--
To UN
For those who care. Here is how you determine the disk space used for each
postgresql db.
#!/bin/bash
# scan the list of databases and provide the disk space used in human
readable form
dbs=`psql template1 -tc "select datname from pg_database"|sed s/" "/""/g`
for i in $dbs
do
oid=`psql template
On Sun, Oct 29, 2006 at 12:18:54PM -0500, 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.
-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 taki
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/29/06 14:07, Steve Kemp wrote:
> On Sun, Oct 29, 2006 at 03:00:38PM -0500, Roberto C. Sanchez wrote:
>
>>> [EMAIL PROTECTED]:~# du --summarize --human-readable /var/lib/mysql/*
>
>> He is working with PostgreSQL.
>
> True, but I figured th
On Sun, Oct 29, 2006 at 03:00:38PM -0500, Roberto C. Sanchez wrote:
> > [EMAIL PROTECTED]:~# du --summarize --human-readable /var/lib/mysql/*
> He is working with PostgreSQL.
True, but I figured that the ability to determine which files
were the biggest was the next remaining issue. (After
On Sun, Oct 29, 2006 at 12:18:54PM -0500, 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.
On Sun, Oct 29, 2006 at 05:31:19PM +, Steve Kemp wrote:
> On Sun, Oct 29, 2006 at 12:18:54PM -0500, Tony Heal wrote:
> > OK, how do you determine the disk size of a database.
>
> The same way that you'd determine what disk space were used by
> any other type of file.
>
> > but it would be
On Sun, Oct 29, 2006 at 12:18:54PM -0500, Tony Heal wrote:
> OK, how do you determine the disk size of a database.
The same way that you'd determine what disk space were used by
any other type of file.
> but it would be easier if I knew which DB's were taking up what disk
> space.
Try this:
nchez [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
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 pos
11 matches
Mail list logo
