Re: Replication broken. Stale data in slave Database

Поиск
Список
Период
Сортировка
От Gilberto Castillo
Тема Re: Replication broken. Stale data in slave Database
Дата
Msg-id 40347.192.168.207.54.1435171274.squirrel@webmail.etecsa.cu
обсуждение исходный текст
Ответ на Re: Replication broken. Stale data in slave Database  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
Ответы Re: Replication broken. Stale data in slave Database
Список pgsql-admin
> Not sure if I can do that when the master database is shut down

Yes, In fact both server must be turned off for safety.


> On 24 Jun 2015 6:36 pm, "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
> wrote:
>
>> > Hi,
>> >
>> > Yes we have failover. If after a few minutes the master database goes
>> up
>> > the replication works again which is fine.
>> >
>> > But I need something that deletes all records in the slave database
>> > meanwhile master database is down. The reason is because we are
>> sending
>> > not
>> > updated data when this happens and we prefer deleted what it is in the
>> > slave database.
>>
>> Uhmmmm, use rsync of the folder wal in the master and slave.
>>
>>
>>

Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba



В списке pgsql-admin по дате отправления:

Предыдущее
От: Alberto Olivares
Дата:
Сообщение: Re: Replication broken. Stale data in slave Database
Следующее
От: "Saravanan S"
Дата:
Сообщение: PostgreSQL to Oracle DBLink