Re: Connections, table locks, disk space - Mailing list pgsql-hackers

From Haller Christoph
Subject Re: Connections, table locks, disk space
Date
Msg-id 200110100937.LAA05185@rodos
Whole thread Raw
List 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 



pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: Encoding issues
Next
From: "Balaji Venkatesan"
Date:
Subject: Setting Password