> In MySQL the database files are housed in directories named for the
> database they belong to and you can see how much disk space they are
> taking up fairly easily. Where does PostgreSQL keep is datafiles and
> more importantly how can I tell how much diskspace it is consuming?
In order to start the postmaster you had to
$ initdb -D /yourdatadir
$ postmaster -D /yourdatadir
If you followed the install files´ instructions and compiled it yourself
/yourdatadir should be /usr/local/pgsql/data. If you are using a
postgresql database which came with your distro it may be in something
like /var/pgsql/data (That´s how Mandrake is set up...it´s also got a
/var/pgsql/data and makes routine pg_dumpalls).
Daniel R. Anderson
Chief Lab Rat and Helper Monkey
Great Lakes Industries, Inc.
"Never let your schooling interfere with your education¨
-- Mark Twain
In response to
pgsql-general by date
|Next:||From: Ben||Date: 2003-03-29 19:43:16|
|Subject: variable-count stored proc arguements?|
|Previous:||From: Ben||Date: 2003-03-29 19:33:41|
|Subject: Recursive Stored Procs?|