The sofia profiles will always try to recreate the indexes when the module loads. You can either ignore these, or configure sofia to skip the schema update on startup. William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com On 6/18/15 5:52 AM, Roman Dissauer wrote:
Hey,
I started using my PostgreSQL database for freeswitch core and sofia_reg_internal. All works fine but every time I start the internal profile I get a bunch of errors:
2015-06-18 13:58:48.471346 [NOTICE] sofia.c:5565 Connecting ODBC Profile internal [sofia_reg_internal] 2015-06-18 13:58:48.489141 [ERR] switch_pgsql.c:645 Error executing query: FEHLER: Relation „sr_call_id“ already exists
2015-06-18 13:58:48.489515 [ERR] switch_pgsql.c:645 Error executing query: FEHLER: Relation „sr_sip_user“ already exists
...
This errors didn’t appear when I was using MySQL ODBC Database connector. As I said, everything works fine but maybe I’m overlooking something and I don’t want to run into some serious troubles.
My Freeswitch version Info: FreeSWITCH Version 1.4.18+git~20150312T185523Z~4eed221b69~64bit (git 4eed221 2015-03-12 18:55:23Z 64bit)
running on CentOS 7.1 with PostgreSQL 9.4
Thanks, Roman _________________________________________________________________________ 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-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