Re: Most efficient way to initialize a standby server

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: Edson Richter <edsonrichter(at)hotmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Most efficient way to initialize a standby server
Date: 2013-05-28 03:03:58
Message-ID: 51A41E9E.30109@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2013-05-28 03:07:35 Re: Most efficient way to initialize a standby server
Previous Message Sergey Konoplev 2013-05-28 00:43:44 Re: Most efficient way to initialize a standby server