Re: Replication broken. Stale data in slave Database - Mailing list pgsql-admin

From Alberto Olivares
Subject Re: Replication broken. Stale data in slave Database
Date
Msg-id CAGdoAzj5YHWtEnyoN6QNJpqwbXS009D0bUbLdiHHiAhryyR02Q@mail.gmail.com
Whole thread Raw
In response to Re: Replication broken. Stale data in slave Database  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Responses Re: Replication broken. Stale data in slave Database  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
List pgsql-admin

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.

On 24 Jun 2015 6:03 pm, "Gilberto Castillo" <gilberto.castillo@etecsa.cu> wrote:

> Hi,
>
> I thought about creating a cron job but we cannot run it monthly, we need
> to do it just in case the replication fails because the master database
> breaks.

You not use failover?
What use for manager the replication?


Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba


Winner of IHS Jane's ATC Award - Enabling Technology

pgsql-admin by date:

Previous
From: "Gilberto Castillo"
Date:
Subject: Re: Replication broken. Stale data in slave Database
Next
From: "Gilberto Castillo"
Date:
Subject: Re: Replication broken. Stale data in slave Database