pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Treat <robert@omniti.com>
To: pgsql-admin@postgresql.org
Cc: Milen A. Radev <milen@radev.net>
Subject: Re: Checking a  size of a given database
Date: Tue, 17 Apr 2007 22:01:48 -0400
Message-ID: <200704172201.49061.robert@omniti.com> (raw)
In-Reply-To: <f02blk$lnp$1@sea.gmane.org>
References: <4624A530.40108@rokcorp.com>
	<f02blk$lnp$1@sea.gmane.org>

On Tuesday 17 April 2007 07:39, Milen A. Radev wrote:
> Chuck Amadi написа:
> > I have been given a task to try a proof of concept of migrating are
> > active databases from PostgreSQL 8.0.1 to 8.2.3
> >
> > I will install and configPostgreSQL on my local w/s and replicate the
> > database users etc etc.
> >
> > I have had a look inside /var/lib/pgsql/data/base and there are
> > numerous  files (db's) which I believe is where I can check data base
> > size.
> >
> > 1  108012  114465  122407  1261267  1261963  17229  17233  17234  17235
> > 174066  19247  205009  21272  2793694  2794334  333245  333375
> >
> > I am aware that Postgresql creates directories to keep each database in.
> > These directories aren't names,they are kept as the *'OID's *of each
> > database (oid's are*"object identifiers"*).
> >
> > Previously I just run pg_dump and thus run ls -lh on the db dump. Anyway
> > of checking a  size of a given database I have tried
> > the sql using select pg_database_size ('dbaname'); but no joy.
>
> What does it mean "but no joy"? What was the error message?

Well, given that the function doesn't exist in 8.0.1, I'd guess it means that 
it didn't work for him.  In 8.0.x you need to use the dbsize contrib module 
to get database size, or match things up manually on disk with select 
oid,datname from pg_database. 

-- 
Robert Treat
Database Architect
http://www.omniti.com



view thread (6+ messages)  latest in thread

Message-ID: <200704172201.49061.robert@omniti.com>
Permalink:  ../200704172201.49061.robert@omniti.com/
Also on:    postgresql.org/message-id/200704172201.49061.robert@omniti.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: robert@omniti.com, milen@radev.net
  Subject: Re: Checking a  size of a given database
  In-Reply-To: <200704172201.49061.robert@omniti.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox