Re: How to switch file systems with least downtime?

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: CS DBA <cs_dba(at)consistentstate(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to switch file systems with least downtime?
Date: 2013-09-14 17:27:01
Message-ID: CAJ4CxLkioNAx2Mq7Pw9RjLLhC6pxrOPcmy-kRhtdkNPFZigeKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Sep 14, 2013 at 11:26 AM, CS DBA <cs_dba(at)consistentstate(dot)com> wrote:

> 3) before the swap do another rsync to bring the db as close to sync'ed as
> possible
>
> 4) shut down the primary db
>
> 5) do a final rsync (should have little to nothing to sync)
>
> 6) start the secondary db
>

Thanks. That's how I normally do it, but I was hoping to eliminate much of
the downtime between 4 and 6.

Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-09-14 19:38:32 Re: How to switch file systems with least downtime?
Previous Message Adrian Klaver 2013-09-14 16:57:41 Re: Postgres 9.2.4 "Double Precision" Precision