Re: Replication broken. Stale data in slave Database

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "Alberto Olivares" <alberto(dot)olivares(at)snowflakesoftware(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication broken. Stale data in slave Database
Date: 2015-06-24 16:07:16
Message-ID: 37952.192.168.207.54.1435162036.squirrel@webmail.etecsa.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gilberto Castillo 2015-06-24 16:17:41 Re: Replication broken. Stale data in slave Database
Previous Message Alberto Olivares 2015-06-24 16:01:36 Re: Replication broken. Stale data in slave Database