| Lists: | pgsql-hackers |
|---|
| From: | Guus Kerpel <Guus(at)advance(dot)nl> |
|---|---|
| To: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Size of my data base? |
| Date: | 2000-11-27 15:47:06 |
| Message-ID: | 81A83162A31AD411B8E200E08110459D323097@AIEX01 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
>
| From: | Michael Fork <mfork(at)toledolink(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | pg_trigger and tgargs |
| Date: | 2000-11-30 22:54:27 |
| Message-ID: | Pine.BSI.4.21.0011301750000.26275-100000@glass.toledolink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Michael Fork <mfork(at)toledolink(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_trigger and tgargs |
| Date: | 2000-11-30 23:39:04 |
| Message-ID: | Pine.BSF.4.21.0011301536050.48480-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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