X-Original-To: pgsql-admin@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 26B7A925227 for ; Wed, 28 May 2003 08:11:59 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 14578-08 for ; Wed, 28 May 2003 08:11:57 -0400 (EDT) Received: from nil.tinet.org (tinet.org [195.77.216.130]) by developer.postgresql.org (Postfix) with ESMTP id DD1AF9251D9 for ; Wed, 28 May 2003 08:11:56 -0400 (EDT) Received: from tinet.org ([195.76.233.3]) by nil.tinet.org (Netscape Messaging Server 4.1) with ESMTP id HFLJ7L01.13U; Wed, 28 May 2003 14:11:45 +0200 Message-ID: <3ED4A75E.7000103@tinet.org> Date: Wed, 28 May 2003 14:11:10 +0200 From: Daniel Rubio User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Anagha Joshi Cc: "pgsql-admin@postgresql.org" Subject: Re: database size References: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/386 X-Sequence-Number: 8948 In the contrib directory exists the database_size function (dbsize directory, i think) ... And if you want to automate the process of retrieving all your databases size http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=15493 Anagha Joshi wrote: > Hi, > > How can I know size of the specific database in Postgres? > > > > Thx. in advance. > > -Anagha > -- ******************************************************** Daniel Rubio Rodríguez OASI (Organisme Autňnom Per la Societat de la Informació) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007 - Fax: 977.224.517 e-mail: drubio@oasi.org ********************************************************