Replication broken. Stale data in slave Database

Поиск
Список
Период
Сортировка
От Alberto Olivares
Тема Replication broken. Stale data in slave Database
Дата
Msg-id CAGdoAzgERUntgCy-gG2wpL+g3T1rEDDSa+G88=W6pAFXscJ2mw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Replication broken. Stale data in slave Database  (John Scalia <jayknowsunix@gmail.com>)
Re: Replication broken. Stale data in slave Database  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Список 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?

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 по дате отправления:

Предыдущее
От: Ankur Kaushik
Дата:
Сообщение: dump using copy failed
Следующее
От: John Scalia
Дата:
Сообщение: Re: Replication broken. Stale data in slave Database