Re: Growing a live database

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Growing a live database
Date: 2011-05-06 13:51:37
Message-ID: BANLkTi=vyxkMjGyJEmOwu3m9gamVoU5Yeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 6, 2011 at 9:27 AM, Rick Genter <rick(dot)genter(at)gmail(dot)com> wrote:
> I believe that this accomplishes the goal (increasing available drive space)
> with a minimum amount of down time. Am I thinking correctly, or have I
> missed something?
>

That is the general procedure you would follow to perform maintenance
on a busy DB server. Just practice it on a spare set of machines (or
virtual machines, even) and write down *every* step and command you
need to do so you are not thinking of it on the fly.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mason S 2011-05-06 14:13:51 Re: dblink() from GridSQL
Previous Message Jakub Królikowski 2011-05-06 13:42:47 Default Operator Class for datatype