What's the impact of archive_command failing?

Поиск
Список
Период
Сортировка
От David Kerr
Тема What's the impact of archive_command failing?
Дата
Msg-id 20111018155833.GA42275@mr-paradox.net
обсуждение исходный текст
Ответы Re: What's the impact of archive_command failing?  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-general
I have postgres setup for streaming replication and my slave box went down.

My question is, how long can that box stay down before it causes a material impact on the master?

The archive_command that I use will not archive logs while the slave is down.

I know the obvious problems:
 * you're not archiving, so you lose all of the recovery related benefits if you should crash
 * could run out of disk space in pg_xlog
 * your slave could get out of sync

What i'm concerned with is something like, if the master is unable to archive eventually
it will stop writing WALs Or something impacting the performance of the database.
or anything along those lines.

Thanks

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

Предыдущее
От: leddy
Дата:
Сообщение: PostgreSQL - bindings were not allocated properly
Следующее
От: "Vishnu S."
Дата:
Сообщение: POstgreSQL Tablespace deletion issue