I would like to know what is the way to switch the role of 2 servers when using warm standby?
I have 2 servers :
S_2, and at a time T,
S_1 is the master server and
S_2 is a warm standby with streaming replication.
At a later moment, I would like to switch
S_2 become the master server and
S_1 the warm standby.
What do I have to do to switch roles ?