freeswitch cdr mysql_FreeSWITCH折腾笔记3——数据库修改为postgresql

需要修改的配置文件：

switch.conf.xml //核心表

cdr_pg_csv.conf.xml //通话记录db.conf.xml //核心表voicemail.conf.xml //留言相关的表internal.xml //external.xml //fifo.conf.xml //fifo相关的表callcenter.conf.xml //callcenter程序相关的表。

1、switch.conf.xml

2、cdr_pg_csv.conf.xml

3、db.conf.xml、voicemail.conf.xml、internal.xml、external.xml、fifo.conf.xml、callcenter.conf.xml

password

‘ options=‘-c client_min_messages=NOTICE‘ application_name=‘freeswitch‘"/>

或者在var.xml追加以下配置，然后去注释db.conf.xml、voicemail.conf.xml、internal.xml、external.xml、fifo.conf.xml、callcenter.conf.xml 中的" "

【附】xml_cdr建表sql及cdr_pg_csv.conf.xml 字段设置

CREATE TABLE "public"."xml_cdr" (

"uuid" uuid NOT NULL,

"domain_uuid" uuid,

"extension_uuid" uuid,

"domain_name" text COLLATE "default",

"accountcode"