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
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