Re: Checking a size of a given database

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