Skip site navigation (1) Skip section navigation (2)

Re: SOS ---- Could you help me with postgresql.....????

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: alvaro(at)audifarma(dot)com(dot)co
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SOS ---- Could you help me with postgresql.....????
Date: 2004-03-19 14:48:33
Message-ID: 20040319064650.B75424@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, 18 Mar 2004 alvaro(at)audifarma(dot)com(dot)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?


In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-03-19 14:49:10
Subject: Re: Statistics collecting problem
Previous:From: Stephan SzaboDate: 2004-03-19 14:43:04
Subject: Re: create function problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group