Postgres Pro
Downloads
Home   >   mailing lists

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

From John Scalia
Subject Re: Replication broken. Stale data in slave Database
Date
Msg-id CABzCKRCM+mFFPmWrEN0bv=atOHdMO9mVikTEu-4PZyPBcO9xRQ@mail.gmail.com
Whole thread Raw
In response to Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
List pgsql-admin
Tree view
Alberto,

I assume you synchronous streaming replication, but have you looked at asynchronous replication just using WAL files? You could have your standby server lag behind by a fixed amount and maybe then you wouldn't have to delete on failover. Without more details, that's the best I can offer.
--
Jay

On Wed, Jun 24, 2015 at 7:43 AM, Alberto Olivares <alberto.olivares@snowflakesoftware.com> wrote:
Hi all,

We have set up a Streaming replication. 

Master database serves temporal data being replicated on the Slave database.

In the event that we shut down the Master database, the slave database contains residual data that we do not need. 

Is there any way to trigger a SQL to delete all data from the slave database in the event that the replication is broken?

Thank you for your answers.

Regards,
Alberto.

Alberto Olivares Colas
Technical Consultant
Snowflake Software



Winner of IHS Jane's ATC Award - Enabling Technology

Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------




Winner of IHS Jane's ATC Award - Enabling Technology

pgsql-admin by date:

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