bricklen <[email protected]> wrote: > On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
