Re: Most efficient way to initialize a standby server

Em 28/05/2013 00:03, Joshua D. Drake escreveu:
>
> On 05/27/2013 05:43 PM, Sergey Konoplev wrote:
>>
>> Try this step-by-step instruction
>> https://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup.
>> I constantly update it when discovering useful things, including low
>> bandwidth issues.
>>
>> On Mon, May 27, 2013 at 5:08 PM, Edson Richter
>> <edsonrichter@hotmail.com> wrote:
>>> Since 9.0 days I do use script with rsync for transfer. And
>>> sometimes the
>>> servers get out of sync (due large processing in master database and
>>> huge
>>> network latency), and I have to reinitialize the standby server.
>
> I think the use of PITRTools is probably up your alley here.
>
> JD
>
Assume I know nothing about PITRTools (which I really don't know!), can
you elaborate a bit more your suggestion?

Thanks,

Edson