Joel, i use MySQL (i know you're looking for PG) i have added primary keys to most of my tables (Voicemail Preferences, Voicemail Messages, FIFO tables) without any issues, i have yet to test against the the calls & call state tables. I don't think it'd cause any issues except if FreeSWITCH ever tries to rebuild the tables in a later update, at which point you'd have to readd your PK On Wed, Oct 15, 2014 at 10:35 AM, Joel White <joelewhite@gmail.com> wrote:
Not sure
What I am trying to do is setup a Multi-Master replication of all database entries. This way when the system fails over to the secondary or tertiary servers all call details for recovery etc are on that system.
So I am trying to add a primary key to all db tables that I want to be replicated.
I just do not want to run into the situation of FreeSWITCH breaking because it does not understand how to handle the added primary key
On Thu, Oct 9, 2014 at 1:14 AM, Seven Du <dujinfang@gmail.com> wrote:
pg has a hidden oid which is unique, can you use that?
-- Seven Du http://about.me/dujinfang http://www.dujinfang.com http://www.freeswitch.org.cn
Sent with Sparrow <http://www.sparrowmailapp.com/?sig>
On Wednesday, October 8, 2014 at 9:44 PM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org