Re: Cascade streaming replication + wal_files - Pgsql 9.2

Поиск

Список

Период

Сортировка

От	Sameer Kumar
Тема	Re: Cascade streaming replication + wal_files - Pgsql 9.2
Дата	7 июля 2016 г. 05:17:38
Msg-id	CADp-Sm4XQbacTxdVNAj3xpwp5Re-iRaze=F28Xj2pfinxdANpw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Cascade streaming replication + wal_files - Pgsql 9.2 (Patrick B <patrickbakerbr@gmail.com>)
Ответы	Re: Cascade streaming replication + wal_files - Pgsql 9.2 (Patrick B <patrickbakerbr@gmail.com>)
Список	pgsql-general

On Thu, 7 Jul 2016, 10:10 a.m. Patrick B, <patrickbakerbr@gmail.com> wrote:

ok...

I'll archive the wal_files locally on slave01,

How? I assume you are planning on doing this with scp/rsync in archive_command in upstream master.

and then send them to slave02 every 10 minutes, for example.

Sounds good. But why? Is it just to have redundunt archives?

On your upstream master you can also use a custom script which inturn would be scp'ing the wals to 2 or 3 servers for archiving purposes

This will be done by rsync or something else.

I'll have still the problem with timeline, and slave02 won't be able to become a master in the future.

No, you should not have a problem. Since rsync will also copy the timeline related files to slave02

Is that right?

Best Regards

Sameer Kumar | DB Solution Architect

ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

В списке pgsql-general по дате отправления:

От: John R Pierce
Дата: 07 июля 2016 г., 05:15:12
Сообщение: Re: Cascade streaming replication + wal_files - Pgsql 9.2

От: Patrick B
Дата: 07 июля 2016 г., 05:32:26
Сообщение: Re: Cascade streaming replication + wal_files - Pgsql 9.2