On Wed, Apr 23, 2014 at 10:26 AM, Kal Black <kaloblak@xxxxxxxxx> 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 site. Unfortunately, the archive_command functionality is not > available while the server is in standby_mode mode so I am wandering if the > wal archiving could be done successfully using alternative ways like rsync, > lsyncd etc. Does anyone tried to go this path and eventually share his > experience. 9.3 introduced a cascading replication feature [1] that allows you to stream WAL from standbys to other standbys. Instead of a downstream standby you can use pg_receivexlog [2] to receive a WAL stream from the upstream one and write it to a local storage. Also, starting from 9.2, you can make base backups from standbys [3]. [1] http://www.postgresql.org/docs/9.3/static/warm-standby.html#CASCADING-REPLICATION [2] http://www.postgresql.org/docs/9.3/static/app-pgreceivexlog.html [3] http://www.postgresql.org/docs/9.3/static/app-pgbasebackup.html -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 gray.ru@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
