Re: What to do if space for database decrease and no additional hard drive is possible? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: What to do if space for database decrease and no additional hard drive is possible?
Date
Msg-id AANLkTinMVh9Qj9HZXHbiA7RREVbZ2or6WaYeL3xrOQ=C@mail.gmail.com
Whole thread Raw
In response to What to do if space for database decrease and no additional harddrive is possible?  (AlannY <m@alanny.ru>)
List pgsql-general
On Mon, Jul 26, 2010 at 4:43 AM, AlannY <m@alanny.ru> wrote:
> Hi there.
>
> I have a huge database with several tables. Some tables have statistics
> information. And it's very huge. I don't want to loose any of this data.
> But hard drives on my single server are not eternal. Very soon, there will
> be no left space. And the most awful this, that it's a 1U server, and I
> can't install new hard drive.
>
> What can I do to enlarge space, without loosing data and performance?

So, what can you do?  Can you add external storage or some kind?  Get
access to a network mounted drive, at least temporarily?  With the
restrictions you're listing I'm not sure you have a lot of
alternatives but to back up some of those tables, restore them
offsite, then drop the tables on the server.

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Re: What to do if space for database decrease and no additional hard drive is possible?
Next
From: John R Pierce
Date:
Subject: Re: What to do if space for database decrease and no additional hard drive is possible?