Hi Greg, This is what I'm using for setting bucardo up,
echo "Adding DBs" > bucardo add db t1 dbname=db host=m1112 > bucardo add db t2 dbname=db host=m1113 > bucardo add db t3 dbname=db host=m1114 > bucardo add db t4 dbname=db host=m1115 > bucardo add db t5 dbname=db host=m1116 > bucardo add db t6 dbname=db host=m1117 > > echo "DB LIST" > bucardo list dbs > > > echo "Adding tables" > bucardo add table track_data herd=therd > > echo "TABLE LIST" > bucardo list tables > > > bucardo add dbgroup tgroup t1:source t2:source t3:source t4:source > t5:source t6:source > > > bucardo add sync nsync herd=therd dbs=tgroup autokick=true > > > bucardo add customcols public.track_data "select seq_no, src_id, dest_id, > m_len, data, month, year, time_of_day, track_id, latlonalt" db=t1 sync=nsync > bucardo add customcols public.track_data "select seq_no, src_id, dest_id, > m_len, data, month, year, time_of_day, track_id, latlonalt" db=t2 sync=nsync > bucardo add customcols public.track_data "select seq_no, src_id, dest_id, > m_len, data, month, year, time_of_day, track_id, latlonalt" db=t3 sync=nsync > bucardo add customcols public.track_data "select seq_no, src_id, dest_id, > m_len, data, month, year, time_of_day, track_id, latlonalt" db=t4 sync=nsync > bucardo add customcols public.track_data "select seq_no, src_id, dest_id, > m_len, data, month, year, time_of_day, track_id, latlonalt" db=t5 sync=nsync > bucardo add customcols public.track_data "select seq_no, src_id, dest_id, > m_len, data, month, year, time_of_day, track_id, latlonalt" db=t6 sync=nsync > > > sudo bucardo start > Regards, Vineet Menon On 4 August 2015 at 08:06, Greg Sabino Mullane <[email protected]> wrote: > On Thu, Jul 09, 2015 at 01:12:20PM +0530, Vineet Menon wrote: > > and my customcols is, > > select id, src_id, dest_id, m_len > > > > While sync-ing, I expect the insert_timestamp to be different from in > both > > dbs. But, it isn't. > > Sorry for the delay. Can you share the commands you use to setup the > sync and the customcols? > > -- > Greg Sabino Mullane [email protected] > End Point Corporation > PGP Key: 0x14964AC8 >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
