Postgres Pro
Downloads
Home   >   mailing lists

Thread: Size of my data base?

Size of my data base?

From
Guus Kerpel
Date:
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

Re: Size of my data base?

From
"Mitch Vincent"
Date:
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@advance.nl>
To: <pgsql-hackers@postgresql.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
>

pg_trigger and tgargs

From
Michael Fork
Date:
I was wondering if someone could tell me if I have gotten the fields of
tgargs correct:

<unnamed>\000 -- Constraint name?

foreign_table_multi\000 -- table with foreign key(s)

primary_table_multi\000 -- table with primary key(s)

UNSPECIFIED\000         -- ??

foreign_int_1\000       -- 1st field in foreign key

primary_int_1\000       -- 1st field in referenced primary key

foreign_int_2\000       -- 1st field in foreign key

primary_int_2\000       -- 1st field in referenced primary key

Thanks

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio

Re: pg_trigger and tgargs

From
Stephan Szabo
Date:
On Thu, 30 Nov 2000, Michael Fork wrote:

> I was wondering if someone could tell me if I have gotten the fields of
> tgargs correct:
For foreign key constraints, yes.  Other triggers can use tgargs for
whatever they want.
> <unnamed>\000 -- Constraint name?
Yes.

> foreign_table_multi\000 -- table with foreign key(s)
> primary_table_multi\000 -- table with primary key(s)
Yep.
> UNSPECIFIED\000         -- ??
What match type was specified (or unspecified if none was specified).

> foreign_int_1\000       -- 1st field in foreign key
> 
> primary_int_1\000       -- 1st field in referenced primary key
> 
> foreign_int_2\000       -- 1st field in foreign key 
> primary_int_2\000       -- 1st field in referenced primary key
2nd on the latter two, but yes in general