[Bucardo-general] Custom cols not working.

[Vineet Menon]

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 <greg at endpoint.com> 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 greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150804/0c44ee91/attachment.html>