From: Chuck Amadi <chuck.amadi@rokcorp.com>
To: postgresql <pgsql-admin@postgresql.org>
Subject: Checking a size of a given database
Date: Tue, 17 Apr 2007 11:45:04 +0100
Message-ID: <4624A530.40108@rokcorp.com> (raw)
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.
Cheers
Chuck
--
Chuck Amadi
ROK Corporation Limited
Ty ROK,
Dyffryn Business Park,
Llantwit Major Road,
Llandow,
Vale Of Glamorgan.
CF71 7PY
Tel: 01446 795 839
Fax: 01446 794 994
International Tel: +44 1446 795 839
email: chuck.amadi@rokcorp.com
This email is confidential to the addressee only. If you do not believe
that you are the intended recipient, do not pass it on or copy it in any
way. Please delete it immediately.
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: chuck.amadi@rokcorp.com
Subject: Re: Checking a size of a given database
In-Reply-To: <4624A530.40108@rokcorp.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