[Freeswitch-users] PostgreSQL core and reg db

[William King]

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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>