scheduled switchover

[francois pascual <fradu84@xxxxxxxxx>]

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