I see. Thanks Jeff,
On Mon, Sep 11, 2017 at 2:38 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > On Mon, Sep 11, 2017 at 7:02 AM, Dave Florek <dave.a.flo...@gmail.com> > wrote: > >> Hi, >> >> I'm trying to setup streaming replication on a cluster of postgresql >> databases and I followed the instructions outlined here ( >> https://wiki.postgresql.org/wiki/Streaming_Replication) but I'm stuck on >> the archive and restore commands. In reading the comments from the archive >> command, WAL archiving needs a shared directory between the primary and >> standby machines in order to replicate. Is this something actually >> required? If so, does postgresql have any recommendations on where this >> shared directory ought to be hosted? >> > > You can use streaming replication without any WAL archive at all. If the > only reason you want a WAL archive is so that the standby can fall behind > the primary without losing the ability to catch back up again, then you can > use a replication slot to make the primary hold onto WAL files until the > standby is done with them. That is going to be simpler than using a WAL > archive, provided the master has enough room to keep them around should the > standby fail for a while. > > If you want a WAL archive for other reasons, then the choice of how to > host it would depend on those reasons. > > Cheers, > > Jeff >
