Postgres Pro
Downloads
Home   >   mailing lists

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

From Alberto Olivares
Subject Replication broken. Stale data in slave Database
Date
Msg-id CAGdoAzgERUntgCy-gG2wpL+g3T1rEDDSa+G88=W6pAFXscJ2mw@mail.gmail.com
Whole thread Raw
Responses Re: Replication broken. Stale data in slave Database
Re: Replication broken. Stale data in slave Database
List pgsql-admin
Tree view
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: Ankur Kaushik
Date:
Subject: dump using copy failed
Next
From: John Scalia
Date:
Subject: Re: Replication broken. Stale data in slave Database