Hi all,<br /><br /> replication is a complex topic, so I tried to get a systematic view on it. Among others I found 4
mutuallyindependent (?) concepts:<br /><ul><li>Log-Shipping vs. Streaming (LS vs. S)<br /><li>Physical Format vs.
LogicalDecoded Format (PFo vs. LFo)<br /><li>Synchronous vs. asynchronous transfer (STr vs ASTr)<br /><li>hot standby
vs.warm standby<br /></ul> 'Mutually independent' implies that there are 2 power 4 = 16 possible combinations. But I
believe,there are some limitations. <br /><br /> 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:<br /><br /> LS - PFo - ASTr (Asynchronous
Log-shippingin Physical Format)<br /> S - PFo - STr (Synchronous Streaming in Physical Format)<br /> S - PFo -
ASTr (Asynchronous Streaming in Physical Format)<br /> S - LFo - STr (Synchronous Streaming in Logical Format)<br />
S- LFo - ASTr (Asynchronous Streaming in Logical Format)<br /><br /> My questions are:<br /><ol><li>Do you agree to
thissystematization into 4 categories?<li>Do you agree, that only this 5 out of 8 possibilities
exist?</ol><p>Regards<br/> Jürgen Purtz<br /><br />