Re: [GENERAL] WAL log archival on standby

2015-06-20 Thread Sameer Kumar
On Fri, 19 Jun 2015 13:46 Michael Paquier wrote: On Fri, Jun 19, 2015 at 2:38 PM, James Sewell wrote: Hey All, Is it possible to create WAL archive files on standby servers when using streaming replication? Yes and no, standbys do not archive WAL in ~9.4, but you could use archive_mode = 'al

Re: [GENERAL] WAL log archival on standby

2015-06-18 Thread Michael Paquier
On Fri, Jun 19, 2015 at 2:38 PM, James Sewell wrote: > Hey All, > > Is it possible to create WAL archive files on standby servers when using > streaming replication? > Yes and no, standbys do not archive WAL in ~9.4, but you could use archive_mode = 'always' with the upcoming 9.5. I know I can

[GENERAL] WAL log archival on standby

2015-06-18 Thread James Sewell
Hey All, Is it possible to create WAL archive files on standby servers when using streaming replication? I know I can use archive_command or pg_receivexlog - but these will both result in me sending information to the standby servers which has already been sent via standard streaming replication.