On Fri, Feb 7, 2014 at 03:57:31PM +1100, James Sewell wrote: > I've just noticed that on PostgreSQL 9.3 I can do the following with a master > node A and a slave node B (as long as I have set recovery_target_timeline = > 'latest'): > > 1. Stop Node A > 2. Promote Node B > 3. Attach Node A as slave > > This is sufficient for my needs (I know it doesn't cover a crash), can anyone > see any potential problems with this approach?
I know some people have used rsync to get A to match B after a crash of A and promotion of B. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers