Hi List,
We have been working towards a replication setup with something like
bucardo. The trick is that it seems any/all master-master replication
methods with postgres requires that all tables have a primary key (or at
least some kind of unique data) in order for them to work, and it turns
out not all tables in davical have a such a thing.
In testing, I was able to add primary key to all the tables in davical
that didn't have one easily enough, and so far I can't find any problems
resulting from doing that. But before I put this into production I am
just wondering if anyone has any reason to think this might be a bad
idea? For example, will future upgrades be a problem, or are any
validation/integrity checks going to pop up and cause issues?
Thanks for any thoughts you care to share.
--
Bob Miller
Cell: 867-334-7117
Office: 867-633-3760
Office: 867-322-0362
www.computerisms.ca
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
We have been working towards a replication setup with something like
bucardo. The trick is that it seems any/all master-master replication
methods with postgres requires that all tables have a primary key (or at
least some kind of unique data) in order for them to work, and it turns
out not all tables in davical have a such a thing.
In testing, I was able to add primary key to all the tables in davical
that didn't have one easily enough, and so far I can't find any problems
resulting from doing that. But before I put this into production I am
just wondering if anyone has any reason to think this might be a bad
idea? For example, will future upgrades be a problem, or are any
validation/integrity checks going to pop up and cause issues?
Thanks for any thoughts you care to share.
--
Bob Miller
Cell: 867-334-7117
Office: 867-633-3760
Office: 867-322-0362
www.computerisms.ca
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general