From: | Jürgen Purtz <juergen(at)purtz(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Replication |
Date: | 2016-02-03 18:46:27 |
Message-ID: | 56B24B03.4090401@purtz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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:
1. Do you agree to this systematization into 4 categories?
2. Do you agree, that only this 5 out of 8 possibilities exist?
Regards
Jürgen Purtz
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Moore | 2016-02-03 18:49:22 | update without SET ? |
Previous Message | Andreas Joseph Krogh | 2016-01-30 13:22:58 | Re: GROUP BY overlapping (tsrange) entries |