| From: | Haller Christoph <ch(at)rodos(dot)fzk(dot)de> | 
|---|---|
| To: | fabio3c(at)terra(dot)com(dot)br (=?iso-8859-1?Q?F=E1bio_Santana?=) | 
| Cc: | pgsql-hackers(at)postgresql(dot)org | 
| Subject: | Re: Connections, table locks, disk space | 
| Date: | 2001-10-10 11:37:51 | 
| Message-ID: | 200110100937.LAA05185@rodos | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Hi, 
I've done some research on your request, 
but I could not find very much to help you. 
What I've found about 
1) Connections 
http://www.postgresql.org/idocs/index.php?runtime-config.html
enable LOG_CONNECTIONS (boolean), LOG_PID (boolean) 
to log database users 
2) Table locks 
nothing 
3) Consumed disk space of a specific database 
All database related files are located in 
$PGDATA/base/<database-name> 
So, by summing all file sizes within this 
directory, you should have it. 
As far as I know, the only limitation to a 
database is given by the total disk capacity. 
I hope this helps at least a bit. 
I've looked through the FAQ list too, but 
couldn't find anything which might help you. 
Still, I don't understand why nobody else is 
answering. 
Regards, Christoph 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2001-10-10 12:52:54 | Re: TOAST and TEXT | 
| Previous Message | Mike Mascari | 2001-10-10 10:29:38 | Re: Setting Password |