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.--
On Wed, Jun 24, 2015 at 7:43 AM, Alberto Olivares <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx> 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 ConsultantSnowflake SoftwareTel.: +44 (0)2380 386578Winner of IHS Jane's ATC Award - Enabling TechnologyRegistered in England & Wales. Registered Number: 4294244-----------------------------------------------------------------------------------------
Winner of IHS Jane's ATC Award - Enabling Technology
