bricklen <bricklen@gmail.com> wrote:
> On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra <berto.d.sera@gmail.com> wrote:
>> --all you need to do is switch master and slave so that "master"
>> is the one box you are currently on
>
> That probably isn't a reasonable solution, considering the OP
> mentioned that she was not a professional DBA. Setting up a
> hot/warm standby, failing over, resetting the slave from the new
> master, lather, rinse, repeat is certainly scriptable but
> doesn't seem like the best option here.
Not only that, but she mentioned that her laptop is a Mac and the
office machine is a Linux server. A solution would probably need
to use *logical* copies like pg_dump, slony, or Londiste.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company