Re: Replication broken. Stale data in slave Database

Hi John and Gilberto,

Thanks for your answer.

We have a synchronous streaming replication. Database is PostgreSQL 9.1.15
on linux.

Saludos,
Alberto.

*Alberto Olivares Colas*Technical Consultant
Snowflake Software

Tel.: +44 (0)2380 386578

Email: alberto(dot)olivares(at)snowflakesoftware(dot)com
Website: www.snowflakesoftware.com
Twitter: @sflakesoftware <http://www,twitter(dot)com(at)sflakesoftware/>
Follow us on LinkedIn <http://www.linkedin.com/company/snowflake-software>

*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*

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

On 24 June 2015 at 17:07, Gilberto Castillo <gilberto(dot)castillo(at)etecsa(dot)cu>
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?
> >
>
> What your version PG?
>
>
> Saludos,
> Gilberto Castillo
> ETECSA, La Habana, Cuba
>
>

--
*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*