error with vacuumdb

Lists: pgsql-general
From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: error with vacuumdb
Date: 2005-04-10 22:58:18
Message-ID: 20050410225818.GI439@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hello *,

I run a Database of curently 120 GByte on a 3Ware S-ATA Raid-5 with
3x 147 GByte. Now it was a little bit bigger (around 190 GByte )
and I have tried to use vacuumdb...

Oops!!! I can not cacuumize my Database...

How many diskspace does vacuumdb need ?

OK, if I pgdumpall my Database, I NEED diskspace but with vacuumdb ?

Good night
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)


From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: error with vacuumdb
Date: 2005-04-11 21:36:09
Message-ID: e6887a7ed9905e1cfbfbc0aa334869a7@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

You'll need to post the actual error to the list to have any hope of
receiving good help.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Apr 10, 2005, at 5:58 PM, Michelle Konzack wrote:

> Hello *,
>
> I run a Database of curently 120 GByte on a 3Ware S-ATA Raid-5 with
> 3x 147 GByte. Now it was a little bit bigger (around 190 GByte )
> and I have tried to use vacuumdb...
>
> Oops!!! I can not cacuumize my Database...
>
> How many diskspace does vacuumdb need ?
>
> OK, if I pgdumpall my Database, I NEED diskspace but with vacuumdb ?
>
> Good night
> Michelle
>
> --
> Linux-User #280138 with the Linux Counter, http://counter.li.org/
> Michelle Konzack Apt. 917 ICQ #328449886
> 50, rue de Soultz MSM LinuxMichi
> 0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)