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
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 |