Re: Most efficient way to initialize a standby server - Mailing list pgsql-general

From Edson Richter
Subject Re: Most efficient way to initialize a standby server
Date
Msg-id BLU0-SMTP21BD895563A37223EBE68CCF970@phx.gbl
Whole thread Raw
In response to Re: Most efficient way to initialize a standby server  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Most efficient way to initialize a standby server  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Most efficient way to initialize a standby server
Next
From: 高健
Date:
Subject: How to evaluate disk space needed by a table