Re: [GENERAL] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-24 Thread Sergey Konoplev
On Thu, Apr 24, 2014 at 4:37 AM, Michael Paquier wrote: >> 9.3 introduced a cascading replication feature [1] that allows you to >> stream WAL from standbys to other standbys. > Picky correction: cascading replication has been added in 9.2. Oh, right, pardon me. -- Kind regards, Sergey Konoplev

Re: [GENERAL] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-24 Thread Michael Paquier
On Thu, Apr 24, 2014 at 7:44 AM, Sergey Konoplev wrote: > On Wed, Apr 23, 2014 at 10:26 AM, Kal Black wrote: >> I am trying to figure out if wal archiving from a standby is possible and a >> viable option for a backup strategy on Postgresql 9.3. The idea is to be >> able to take regular base back

Re: [GENERAL] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-23 Thread Sergey Konoplev
On Wed, Apr 23, 2014 at 10:26 AM, Kal Black wrote: > I am trying to figure out if wal archiving from a standby is possible and a > viable option for a backup strategy on Postgresql 9.3. The idea is to be > able to take regular base backups and wal archives from a standby server in > a remote DR si

[GENERAL] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-23 Thread Kal Black
Hello I am trying to figure out if wal archiving from a standby is possible and a viable option for a backup strategy on Postgresql 9.3. The idea is to be able to take regular base backups and wal archives from a standby server in a remote DR site. Unfortunately, the archive_command functionality i