Re: replication consistency checking

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: replication consistency checking
Дата
Msg-id CAEyp7J_ccGRLXnb6-qB2R=-fgUc7OUYLGSvhupRbshXbsVWuYQ@mail.gmail.com
обсуждение исходный текст
Ответ на replication consistency checking  (hydra <hydrapolic@gmail.com>)
Ответы Re: replication consistency checking  (hydra <hydrapolic@gmail.com>)
Список pgsql-admin


On Thu, Jun 4, 2015 at 2:49 PM, hydra <hydrapolic@gmail.com> wrote:
After setting up streaming replication, is it possible to check whether the slave has the same data as the master?


Yes. There are quite a few ways to check the sync status between master and standby. Which version of PostgreSQL are you using by the way ? 

Generally, you can easily build some scripts and schedule them in cron to check the status. You can use functions or catalog views to monitor the status, this depends on the version of PG you are using.

You can also use tools like "repmgr" to monitor and manage replication. I am not 100% sure how good or efficient it is.

Regards,
Venkata Balaji N

Fujitsu Australia

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

Предыдущее
От: hydra
Дата:
Сообщение: replication consistency checking
Следующее
От: hydra
Дата:
Сообщение: Re: replication consistency checking