| From: | "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu> |
|---|---|
| To: | "Alberto Olivares" <alberto(dot)olivares(at)snowflakesoftware(dot)com> |
| Cc: | gilberto(dot)castillo(at)etecsa(dot)cu, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Replication broken. Stale data in slave Database |
| Date: | 2015-06-24 18:41:14 |
| Message-ID: | 40347.192.168.207.54.1435171274.squirrel@webmail.etecsa.cu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)castillo(at)etecsa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2015-06-24 22:08:55 | Re: PostgreSQL to Oracle DBLink |
| Previous Message | Gilberto Castillo | 2015-06-24 18:36:12 | Re: Replication broken. Stale data in slave Database |