Re: Restore master from slave

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "sonnix" <sonnix(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Restore master from slave
Date: 2011-05-31 13:45:40
Message-ID: 4DE4AAB4020000250003DED9@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

sonnix <sonnix(at)gmail(dot)com> wrote:

> Can i make only base backup from temporary master to main master?

You didn't say which version of PostgreSQL you're using, what OS
it's running on, how you're managing the replication, or what
exactly you did -- so it's hard to give very specific advice. That
said, I'm pretty sure that the answer to the above question is that
when you promote a standby to be the new master, you must do a base
backup from it to anything to which you want to replicate
transactions from the new master -- including the old master. If
you have rsync available, you can probably do this very quickly if
you use the right options.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tatsuo Ishii 2011-05-31 15:14:30 Re: pgpool versus sequences
Previous Message Tom Lane 2011-05-31 13:33:34 pgpool versus sequences (was Re: [ADMIN] 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?)