Replication

 Hi all,

 replication is a complex topic, so I tried to get a systematic view on it. Among others I found 4 mutually independent (?) concepts:
Log-Shipping vs. Streaming (LS vs. S)
Physical Format vs. Logical Decoded Format (PFo vs. LFo)
Synchronous vs. asynchronous transfer (STr vs ASTr)
hot standby vs. warm standby
 'Mutually independent' implies that there are 2 power 4 = 16 possible combinations. But I believe, there are some limitations. 

 First, hot and warm standby (at the standby site) are possible in all cases. Second, for me the following 5 out of 8 seems to be possible:

 LS - PFo - ASTr  (Asynchronous Log-shipping in Physical Format)
 S - PFo - STr      (Synchronous Streaming in Physical Format)
 S - PFo - ASTr  (Asynchronous Streaming in Physical Format)
 S - LFo - STr    (Synchronous Streaming in Logical Format)
 S - LFo - ASTr  (Asynchronous Streaming in Logical Format)

 My questions are:
Do you agree to this systematization into 4 categories?
Do you agree, that only this 5 out of 8 possibilities exist?
Regards
 Jürgen Purtz