Re: Restore master from slave - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Restore master from slave
Date
Msg-id 4DE4AAB4020000250003DED9@gw.wicourts.gov
Whole thread Raw
In response to Restore master from slave  (sonnix <sonnix@gmail.com>)
List pgsql-admin
sonnix <sonnix@gmail.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

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Insert statement deletes older table records
Next
From: Wells Oliver
Date:
Subject: Server crash... trying to figure it out