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

From Joshua D. Drake
Subject Re: Most efficient way to initialize a standby server
Date
Msg-id 51A41E9E.30109@commandprompt.com
Whole thread Raw
In response to Re: Most efficient way to initialize a standby server  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Most efficient way to initialize a standby server
List pgsql-general
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



pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Most efficient way to initialize a standby server
Next
From: Edson Richter
Date:
Subject: Re: Most efficient way to initialize a standby server