I want to implement streaming replication using postgresql-9.2.4 in my reporting application. I came stuck on the below scenario.
- create master and slave with synchronous replication which is working fine.
- then I brought down master and brought up slave as master using trigger file on slave side manually.
- fired log in new master which is working fine.
Now my question is that how can I bring up the old master as slave so that it points to new master without taking base backup or using
My reporting application will contain large data (approx 50 TB) and more. If I take base backup or
rsync feature it will surely take more time to sync old master to new master .
Is there any other way or third party tool which help me to avoid base backup?