agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Jürgen Purtz <juergen@purtz.de>
To: pgsql-sql@postgresql.org
Subject: Replication
Date: Wed, 3 Feb 2016 19:46:27 +0100
Message-ID: <56B24B03.4090401@purtz.de> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
view thread (10+ messages) latest in thread
Message-ID: <56B24B03.4090401@purtz.de>
Permalink: ../56B24B03.4090401@purtz.de/
Also on: postgresql.org/message-id/56B24B03.4090401@purtz.de
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: juergen@purtz.de
Subject: Re: Replication
In-Reply-To: <56B24B03.4090401@purtz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox