I'm unclear on the prerequisites for what must be a very common scenario:
There are three PostgreSQL machines: A, B, and C. B and C are slaves off of the master, A. A fails, and B is promoted to being the new master. Can C just be pointed at A and have it "just work"?