Skip site navigation (1) Skip section navigation (2)

Re: Size of my data base?

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Guus Kerpel" <Guus(at)advance(dot)nl>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Size of my data base?
Date: 2000-11-30 19:17:28
Message-ID: 008a01c05b02$2e8c9040$0200000a@windows (view raw or flat)
Thread:
Lists: pgsql-hackers
If you installed in the default directory then the files relating to a
database are in

/usr/local/pgsql/data/base/<databasename>

So you could just total up the size of everything under that directory.

-Mitch
----- Original Message -----
From: "Guus Kerpel" <Guus(at)advance(dot)nl>
To: <pgsql-hackers(at)postgresql(dot)org>
Sent: Monday, November 27, 2000 7:47 AM
Subject: [HACKERS] Size of my data base?


> Hi everybody,
>
>
> there must be a nice way of getting the size of my database (in mB,
> preferably), but I couldn't find it in the documentation that I searched
> through briefly.
>
> The reason why I wanna do this is because the server might get full
quickly
> and to make sure it doensn't happen before I know I'm writing a script
that
> sends me the size of this database per mail.
>
> Can anyone direct me to an answer to this problem?
>
> I would be most thankful,
>
>
> Gus
>


In response to

Responses

pgsql-hackers by date

Next:From: Don BaccusDate: 2000-11-30 19:59:47
Subject: Re: SQL 'in' vs join.
Previous:From: Tom LaneDate: 2000-11-30 18:07:53
Subject: Re: location of Unix socket

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group