Re: streaming replication does not work across datacenter with 20ms latency?

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: streaming replication does not work across datacenter with 20ms latency?
Дата
Msg-id 67a81ecff1e2fa67bbab94a310f2cd7b.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Re: streaming replication does not work across datacenter with 20ms latency?  (Yan Chunlu <springrider@gmail.com>)
Ответы Re: streaming replication does not work across datacenter with 20ms latency?  (Yan Chunlu <springrider@gmail.com>)
pgpool HA not working  (Sanjay Rao <srao@noida.interrasystems.com>)
Список pgsql-general
On 24 Červenec 2011, 6:09, Yan Chunlu wrote:
> thanks for all the help!
>
> @Adrian:  yes, only one instance on each machine
>
> not the slave finally started and could be connect, replication didn't
> begin, just following errors:
> https://gist.github.com/1102225

These errors just mean the master already removed WAL segments, so the
slave can't actually start the replication because there'd be a gap. This
usually happens with enough write activity (inserts, updates) when the
slave is being setup.

Whaht is your wal_keep_segments value? Increase it or set up WAL
archiving, so that the slave can get the data.

Tomas


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

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: Implementing "thick"/"fat" databases
Следующее
От: Yan Chunlu
Дата:
Сообщение: Re: streaming replication does not work across datacenter with 20ms latency?