Re: Cascade streaming replication + wal_files - Pgsql 9.2
От
John R Pierce
Тема
Re: Cascade streaming replication + wal_files - Pgsql 9.2
Дата
Msg-id
7c6f29b5-2e0d-c4fe-dd05-c4cec1e8d3b5@hogranch.com
Ответ на
Re: Cascade streaming replication + wal_files - Pgsql 9.2 (Sameer Kumar)
Список
Дерево обсуждения
Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce <pierce@hogranch.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce <pierce@hogranch.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce <pierce@hogranch.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce <pierce@hogranch.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar <sameer.kumar@ashnik.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B <patrickbakerbr@gmail.com>
On 7/6/2016 6:52 PM, Sameer Kumar wrote:
the only way to archive the wal_files from a slave into another slave on PostgreSQL 9.2, is by using pg_reveivexlog?Yes. Though I have never tried this myself but going by the theory, it should work.
a slave doesn't generate wal_files at all.
if your master is keeping a wal_archive, slaves, including cascaded streaming slaves, can all use that same archive as their wal source, these are only used for catchup when streaming is interrupted.
-- john r pierce, recycling bits in santa cruz
В списке pgsql-general по дате отправления