Re: Replication broken. Stale data in slave Database

Поиск
Список
Период
Сортировка
От Alberto Olivares
Тема Re: Replication broken. Stale data in slave Database
Дата
Msg-id CAGdoAzg60bzjQS8=jLqSv03s9hsTapaJ2KdYtOzUE6cD0Maj+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication broken. Stale data in slave Database  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Ответы Re: Replication broken. Stale data in slave Database  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Список pgsql-admin

Not sure if I can do that when the master database is shut down

On 24 Jun 2015 6:36 pm, "Gilberto Castillo" <gilberto.castillo@etecsa.cu> wrote:
> Hi,
>
> Yes we have failover. If after a few minutes the master database goes up
> the replication works again which is fine.
>
> But I need something that deletes all records in the slave database
> meanwhile master database is down. The reason is because we are sending
> not
> updated data when this happens and we prefer deleted what it is in the
> slave database.

Uhmmmm, use rsync of the folder wal in the master and slave.



Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba


Winner of IHS Jane's ATC Award - Enabling Technology

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

Предыдущее
От: "Gilberto Castillo"
Дата:
Сообщение: Re: Replication broken. Stale data in slave Database
Следующее
От: "Gilberto Castillo"
Дата:
Сообщение: Re: Replication broken. Stale data in slave Database