Message-ID: <4DAC7205.8080203@kemen.it>
Date: Mon, 18 Apr 2011 19:16:53 +0200
From: rd <rudi.pettazzi@kemen.it>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.14) Gecko/20110223 Thunderbird/3.1.8
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Streaming replication: rsync to switchover
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I've setup streaming replication + file-based log-shipping, with a 
hot-standby.

Everything's good, except I don't know which is the correct way to sync 
the once-master db with the newly promoted master after a switchover,

1) I shutdown the master and touch the trigger_file on the slave. Now 
the slave becomes the master.
2) On the old-master I create recovery.conf + archive directory for 
file-based log-shipping.
3) I hope I can setup the old-master with a simple rsync, because the 
operation could be really fast, being M and S almost identical, but I'm 
not sure about the correct way to rsync them:

a) should I rsync --delete?
b) should I delete the pg_xlog of the old master, before rsyncing? (I'm 
wondering what could happen if some of them never made its way to the 
slave, that now has become new-master)
c) am I missing something? For example, I've read somewhere that one 
should copy pg_control and pg_stat from the old slave to the new slave 
but it doesn't make sense to me.


thanks for any hint,


-- 
rudi pettazzi