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

From Gilberto Castillo
Subject Re: Replication broken. Stale data in slave Database
Date
Msg-id 40206.192.168.207.54.1435170972.squirrel@webmail.etecsa.cu
Whole thread Raw
In response to Re: Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
Responses Re: Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
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.

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



Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba



pgsql-admin by date:

Previous
From: Alberto Olivares
Date:
Subject: Re: Replication broken. Stale data in slave Database
Next
From: Alberto Olivares
Date:
Subject: Re: Replication broken. Stale data in slave Database