Re: Streaming replication failed to start scenarios

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "chinnaobi *EXTERN*" <chinnaobi(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Streaming replication failed to start scenarios
Date: 2012-10-17 09:48:43
Message-ID: D960CB61B694CF459DCFB4B0128514C2089025CA@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

chinnaobi wrote:
>> When the standby is promoted, it starts a new time line, so it
>> is on a different time line from the old master. The old
>> primary cannot be turned to a standby without a new base backup
>> (possibly via rsync to speed up things).

> But taking 200 GB to 500 GB DB base backup is impossible for me. Is
there
> any other solution ??

But you must take backups anyway, right?

Using rsync should make the backup much faster if nothing
much has happened since failover.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fathi Ben Nasr 2012-10-17 10:35:22 PostgreSQL Magazine
Previous Message chinnaobi 2012-10-17 09:38:51 Re: How to avoid base backup in automated failover