Layouts for organizing backup & recovery by means of PostgreSQL:<br /> - PITR (fsync, backup_label, history file, pg_controldata);<br /> - streaming (the problem of a "detached" archive);<br /> - pg_basebackup (master, standby);<br /> - pg_archivecleanup;<br /> - pg_receivexlog.<br /> <br /> Logical replication based on PgQ:<br /> - redo & undo functionality for queues;<br /> - fast creation of a replica's copy.<br />