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 CAJ4CxL=h+=hre5pf1nyEWt06VV4RsgJwj73OiBTUzjBSe9FgRQ@mail.gmail.com
Whole thread Raw
In response to Re: How to switch file systems with least downtime?  (Michael Nolan <htfoot@gmail.com>)
Responses Re: How to switch file systems with least downtime?  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-general
On Sat, Sep 14, 2013 at 9:40 AM, Michael Nolan <htfoot@gmail.com> wrote:
Have you considered setting up a synchronously replicated slave database on the new file system (using a port other than 5432), getting it in sync, then shutting both databases down (master first), switching the slave over to become the master and restarting just that database on port 5432?

Not a bad idea, but in this case, a small amount of downtime is preferable over going to that level of effort.


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: Michael Nolan
Date:
Subject: Re: How to switch file systems with least downtime?
Next
From: CS DBA
Date:
Subject: Re: How to switch file systems with least downtime?