On Thu, Aug 22, 2013 at 04:28:52AM -0400, Alex Balashov wrote: > On 08/22/2013 04:27 AM, eric machine wrote: > > >Is there any way which I can achieve with bucardo? > > > >I am using an existing open source system. Thus changing their design is > >really a bad idea, after all there are total of 60 out of 400 tables > >which have no primary keys. > > Unfortunately, this is not an option. Bucardo refers to changed > rows by their primary key, and since it stores change metadata in > the database itself, it's not flexible about the database constructs > used to refer to the changed rows. > > You just need to fix the bad design, I'm afraid.
While I agree you should fix the bad design, you might be able to use a fullcopy sync to copy the way you want. That will re-copy the entire contents of the table each time something changes. This is only reasonable, of course, for relatively small tables. -- Josh Tolley [email protected] 801-987-0252 End Point Corporation http://www.endpoint.com
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
