Re: [Bucardo-general] Master-Slave setup.

From: Periko Support <pheriko(dot)support(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [Bucardo-general] Master-Slave setup.
Date: 2016-10-17 21:50:45
Message-ID: CAK2yrTYVV7YGe46bs53Tr-+goQWpnGX3gk=hKWQ=FaJDEMsYYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Excellent, Yes I can make a copy before run bucardo the first time and
just add pushdelta to my sync and star working.
Thanks David.

On Mon, Oct 17, 2016 at 10:04 AM, David Christensen <david(at)endpoint(dot)com> wrote:
>> This week will continue testing but I have some doubts in a Master-Slave Setup.
>>
>> The slave db, if I will replicate the master, is prefer to start my
>> slave with empty data? or with a exact copy of my master db?
>
> Hi Periko,
>
> If you can start it with a copy of the master db you save yourself a step. Otherwise you will need to initialize the target in Bucardo either using a onetimesync=1 in the sync definition or copy over using pg_dump out-of-band. Bucardo will not load the data in the target explicitly without being told to, so if you just started with empty data it would only copy the rows over as changes were made to them, probably not the effect you were looking for.
>
> David
> --
> David Christensen
> End Point Corporation
> david(at)endpoint(dot)com
> 785-727-1171
>
>
>

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-10-18 00:22:07 Re: Problem changing default data_directory in PG 9.6 + CentOS6
Previous Message Guyren Howe 2016-10-17 21:01:57 Re: Immutable datastore library?