Hi, I use potgresSQL 8.5 with replication. The primary host and slave host are not in the same place. The bandwidth between master/host is to 10MB. We need to schedule a switchover and I found a solution to use the minimun of bandwith to rebuild the database slave I want to know if somebody use similar procedure?
*Step 1:* Stop host01 (master) *Step 2:* Stop host02 (slave) and start it with master configuration. *Step 3:* build replication on host01 (old_master) *Step 4: * Allow connexion on host02 (INSERT, DELETE, SELECT...) *Step 5:* Stop host02 (master) *Step 6:* Stop host01 (slave) and start it with master configuration. *Step 7:* Build slave on host02 (old_master) *Step 8:* Allow connexion on host01 (master) END. I my case when i build slave host (step 3 and step 4), I use this following command: rsync -av --rsh=ssh --compress --verbose --progress *--exclude base*--exclude pg_xlog --exclude pg_log --exclude postgresql.conf --exclude pg_hba.conf --exclude postmaster.pid * IP:/home/PGDDATA I have add "--excluse base" on rsync. If it's work it's only for the switchover, not when the master host crash. Regards, François
