Skip site navigation (1) Skip section navigation (2)

Re: Database files - personal curiosity

From: "Daniel R(dot) Anderson" <dan(at)mathjunkies(dot)com>
To: "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database files - personal curiosity
Date: 2003-03-29 19:37:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
> 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 
and then 
$ 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´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: BenDate: 2003-03-29 19:43:16
Subject: variable-count stored proc arguements?
Previous:From: BenDate: 2003-03-29 19:33:41
Subject: Recursive Stored Procs?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group