Re: [PHP] Postgres question

2002-03-31 Thread Thalis A. Kalfigopoulos

There is a utiliti under contrib/ called oid2name which returns the name of the object 
given its oid. This will probably help you locate which directories correspond to 
which database.

cheers,
--thalis


On Sat, 30 Mar 2002, Robert Abbate wrote:

 Greetings to all!
 
 I have a webhosting company, and I'm trying to be able to use PHP to
 calculate each of my hosting customer's Postgres database disk usage. It
 doesn't seem as easy as MySQL (since MySQL uses the user name to store all
 their database files).
 
 Does anyone know how I can calculate PostgreSQL disk space usage for each of
 my hosting user accounts?
 
 It seems I'm going to have to find out how Postgres keeps track of which
 user's database name is and it's corresponding number (so far, I've been
 able to determin that Postges uses numbers instead of names).
 
 Can anyone give me some insight?
 
 Thanks!
 Robert
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Postgres question

2002-03-30 Thread Robert Abbate

Greetings to all!

I have a webhosting company, and I'm trying to be able to use PHP to
calculate each of my hosting customer's Postgres database disk usage. It
doesn't seem as easy as MySQL (since MySQL uses the user name to store all
their database files).

Does anyone know how I can calculate PostgreSQL disk space usage for each of
my hosting user accounts?

It seems I'm going to have to find out how Postgres keeps track of which
user's database name is and it's corresponding number (so far, I've been
able to determin that Postges uses numbers instead of names).

Can anyone give me some insight?

Thanks!
Robert



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php