Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> 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@xxxxxxxxxxxx
> 785-727-1171
>
>
>


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux