Re: Least intrusive way to move primary data - Mailing list pgsql-admin

From Armand du Plessis
Subject Re: Least intrusive way to move primary data
Date
Msg-id CANf99sVXaat6PVij43AJhEcX+xzy_gCNx4HKHFS=xjWdVi7icQ@mail.gmail.com
Whole thread Raw
In response to Re: Least intrusive way to move primary data  ("Andrew W. Gibbs" <awgibbs@awgibbs.com>)
List pgsql-admin

On Thu, May 30, 2013 at 12:19 PM, Andrew W. Gibbs <awgibbs@awgibbs.com> wrote:
Going with your first option, a master->slave replication, has the
added benefit that you build the expertise for doing Continuous Point
In Time Recovery, and after you do this storage system migration you
can use that knowledge to put in a place a permanent standby server.
Yes, it is a bit of work, but you'd kill two birds with one stone, and
these are worthwhile birds.  If you've got a busy server, and you want
to do regular back-ups, and you don't have a much more
expensive/sophisticated solution at your behest (or you want to
support load balancing of reads in the future), this is probably
something you want to do anyway.

Thanks Andrew, actually I have a streaming slave running for backups at the moment. It's just not as powerful as the primary. It would probably actually be an option to upgrade it and do the failover as well. 
 

pgsql-admin by date:

Previous
From: Michał Rus
Date:
Subject: Change built-in default privileges for CREATE DATABASE?
Next
From: Rodrigo Barboza
Date:
Subject: How do I know my table is bloated?