Re: Replication broken. Stale data in slave Database

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: Replication broken. Stale data in slave Database
Дата
Msg-id CABzCKRCM+mFFPmWrEN0bv=atOHdMO9mVikTEu-4PZyPBcO9xRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
Список pgsql-admin
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.
--
Jay

On Wed, Jun 24, 2015 at 7:43 AM, Alberto Olivares <alberto.olivares@snowflakesoftware.com> 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 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 по дате отправления:

Предыдущее
От: Alberto Olivares
Дата:
Сообщение: Replication broken. Stale data in slave Database
Следующее
От: "Gilberto Castillo"
Дата:
Сообщение: Re: Replication broken. Stale data in slave Database