Re: Replication broken. Stale data in slave Database

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "Alberto Olivares" <alberto(dot)olivares(at)snowflakesoftware(dot)com>
Cc: gilberto(dot)castillo(at)etecsa(dot)cu, pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication broken. Stale data in slave Database
Date: 2015-06-24 18:36:12
Message-ID: 40206.192.168.207.54.1435170972.squirrel@webmail.etecsa.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

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

Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gilberto Castillo 2015-06-24 18:41:14 Re: Replication broken. Stale data in slave Database
Previous Message Gilberto Castillo 2015-06-24 18:02:47 Re: Replication broken. Stale data in slave Database