Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0A0499FA4B2 for ; Tue, 17 Apr 2007 07:40:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 06222-08 for ; Tue, 17 Apr 2007 07:40:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3BACA9FA217 for ; Tue, 17 Apr 2007 07:40:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from starvinmarvin.rokcorp.com (mail.rokcorp.com [217.33.15.170]) by svr4.postgresql.org (Postfix) with ESMTP id 1F9005AF03A for ; Tue, 17 Apr 2007 10:40:28 +0000 (GMT) Received: from [10.0.11.144] (unknown [213.120.252.2]) by starvinmarvin.rokcorp.com (Postfix) with ESMTP id 743CFD4142 for ; Tue, 17 Apr 2007 11:40:24 +0100 (BST) Message-ID: <4624A530.40108@rokcorp.com> Date: Tue, 17 Apr 2007 11:45:04 +0100 From: Chuck Amadi Reply-To: chuck.amadi@rokcorp.com Organization: Rok Corporation Ltd User-Agent: Thunderbird 1.5.0.10 (X11/20070221) MIME-Version: 1.0 To: postgresql Subject: Checking a size of a given database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/149 X-Sequence-Number: 25213 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.