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

From Gilberto Castillo
Subject Re: Replication broken. Stale data in slave Database
Date
Msg-id 37952.192.168.207.54.1435162036.squirrel@webmail.etecsa.cu
Whole thread Raw
In response to Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
Responses Re: Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
List 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



pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Replication broken. Stale data in slave Database
Next
From: Alberto Olivares
Date:
Subject: Re: Replication broken. Stale data in slave Database