Thanks Rosser for your answer. Other thing, with bucardo what is the difference between in a master-master replica vs master-slave, at the end in both ways the user has a 2nd DB with R/W permission? Thanks. On Thu, Oct 13, 2016 at 9:40 PM, Rosser Schwarz <rosser.schwarz@xxxxxxxxx> wrote: > On Thursday, October 13, 2016, Periko Support <pheriko.support@xxxxxxxxx> > wrote: >> >> 1) My target db must have all the tables created without data on it before >> sync? > > > Yes, tables must exist on the target. Generally, it's easiest to have them > empty, but the bigger concern is conflicts with data from the master. > >> >> 2) In a master-master or master slave, bucardo is best to be reside in the >> main master side? > > > It doesn't really matter, as long as it can reach all the dbs it's > managing. I've run it on the master, on the slave, and on another host > entirely. > > rls > > > > -- > :wq -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
