Postgres Pro
Downloads
Home   >   mailing lists

Re: How to switch file systems with least downtime? - Mailing list pgsql-general

From Moshe Jacobson
Subject Re: How to switch file systems with least downtime?
Date
Msg-id CAJ4CxLkioNAx2Mq7Pw9RjLLhC6pxrOPcmy-kRhtdkNPFZigeKw@mail.gmail.com
Whole thread Raw
In response to Re: How to switch file systems with least downtime?  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-general
Tree view
On Sat, Sep 14, 2013 at 11:26 AM, CS DBA <cs_dba@consistentstate.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@neadwerx.com | www.neadwerx.com

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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres 9.2.4 "Double Precision" Precision
Next
From: Scott Marlowe
Date:
Subject: Re: How to switch file systems with least downtime?