Re: [HACKERS] Streaming replication and WAL archive interactions - Mailing list pgsql-hackers

From Миша Тюрин
Subject Re: [HACKERS] Streaming replication and WAL archive interactions
Date
Msg-id 1423700116.172180820@f103.i.mail.ru
Whole thread Raw
In response to Re: Streaming replication and WAL archive interactions  (Andres Freund <andres@2ndquadrant.com>)
List 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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: libpq's multi-threaded SSL callback handling is busted
Next
From: Andres Freund
Date:
Subject: Re: Typo in logicaldecoding.sgml