Re: [HACKERS] Streaming replication and WAL archive interactions

Миша Тюрин <tmihail@bk.ru>

From: Миша Тюрин <tmihail@bk.ru>

To: Andres Freund <andres@2ndquadrant.com>, Heikki Linnakangas <hlinnakangas@vmware.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, Sergey Burladyan <eshkinkot@gmail.com>

Date: 2015-02-12T00:15:16Z

Lists: pgsql-hackers

>  This should be a very common setup in the field, so how are  people doing it in practice?

One of possible workaround with archive and streaming was to use pg_receivexlog from standby to copy/save WALs to archive. but with pg_receivexlog was also issue with fsync.


[ master ] -- streaming --> [ standby ] -- pg_receivexlog --> [ /archive ]


In that case archive is always in pre standby state and it could be better than had archive broken on promote.
--
Misha