X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8D07FD1E204 for ; Fri, 19 Mar 2004 14:48:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 27294-03 for ; Fri, 19 Mar 2004 10:48:33 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 60758D1DC5D for ; Fri, 19 Mar 2004 10:48:29 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id B737A35311; Fri, 19 Mar 2004 06:48:33 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id B5C4B3530B; Fri, 19 Mar 2004 06:48:33 -0800 (PST) Date: Fri, 19 Mar 2004 06:48:33 -0800 (PST) From: Stephan Szabo To: alvaro@audifarma.com.co Cc: pgsql-admin@postgresql.org Subject: Re: SOS ---- Could you help me with postgresql.....???? In-Reply-To: <44497.200.31.204.249.1079644633.squirrel@audifarm.audifarma.com.co> Message-ID: <20040319064650.B75424@megazone.bigpanda.com> References: <44497.200.31.204.249.1079644633.squirrel@audifarm.audifarma.com.co> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/258 X-Sequence-Number: 12827 On Thu, 18 Mar 2004 alvaro@audifarma.com.co wrote: > Recently We Update our Postgresql database server by installing Postgresql > 7.4.1, we followed the basic installation steps that appear in the install > file, everything was fine till this morning when we realize that the > partition (/var) where we storage the data (/var/lib/pgsql/data) was full, > this partition is 30GB size!!! could you belive it????. When we checkout > the size of the data directory it was 28GB, at the end it was imposible > for us to startup the database normally so we have to remove the > /var/lib/pgsql/data directory, and restore the db from a previous backup > made with (pg_dumpall) and this time the /var/lib/pgsql/data was 8GB size > that is a more accurate size for our database. > > Well till now the story goes to good.. > > BUT I've been the whole morning monitoring (df -v or df -h) the size of > the partition (/var) and is growing up every moment by a rate of 6kb to > 8kb at 11:00 am it was 8GB and now 14:00 is 8.9GB (what a hell is going > on????) if things goes like this next week I'm gonna have the same problem > that today ... please help me Does a vacuum full verbose lower the space taken? If so, can you post its output?