<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">I suspect you will see these errors the first time as it is testing to see if the tables exist to create them. Does the user have permissions to create the schema?<div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Dec 27, 2015, at 10:28 AM, Murugan Pandian <<a href="mailto:manpower13.cse@gmail.com" class="">manpower13.cse@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi,<div class=""><br class=""></div><div class=""> I try to use postgres my core database in freeswitch,But when i try to run freeswitch after changing my switch.conf.xml,Getting following error in console </div><div class=""><br class=""></div><div class=""><p class=""><span class="">2015-12-27 15:21:41.131713 [INFO] switch_core_sqldb.c:3381 Opening DB</span></p><p class=""><span class="">2015-12-27 15:21:41.132636 [DEBUG] switch_pgsql.c:415 Query (delete from channels where hostname='debian-jessie') returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.133062 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "channels" does not exist</span></p><p class=""><span class="">LINE 1: delete from channels where hostname='debian-jessie'</span></p><p class=""><span class=""> </span>2015-12-27 15:21:41.133614 [DEBUG] switch_pgsql.c:415 Query (delete from calls where hostname='debian-jessie') returned PGRES_FATAL_ERROR</p><div class=""><span class=""></span><br class="webkit-block-placeholder"></div><p class=""><span class="">2015-12-27 15:21:41.133983 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "calls" does not exist</span></p><p class=""><span class="">LINE 1: delete from calls where hostname='debian-jessie'</span></p><p class=""><span class=""> ^</span></p><p class="">2015-12-27 15:21:41.134455 [DEBUG] switch_pgsql.c:415 Query (delete from tasks where hostname='debian-jessie') returned PGRES_FATAL_ERROR</p><div class=""><span class=""></span><br class="webkit-block-placeholder"></div><p class=""><span class="">2015-12-27 15:21:41.135202 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "tasks" does not exist</span></p><p class=""><span class="">LINE 1: delete from tasks where hostname='debian-jessie'</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.135612 [DEBUG] switch_pgsql.c:415 Query (select hostname from aliases) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.135955 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "aliases" does not exist</span></p><p class=""><span class="">LINE 1: select hostname from aliases</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.136424 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE aliases) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.136764 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "aliases" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.140727 [DEBUG] switch_pgsql.c:415 Query (select hostname from complete) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.141003 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "complete" does not exist</span></p><p class=""><span class="">LINE 1: select hostname from complete</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.141602 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE complete) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.141952 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "complete" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.145120 [DEBUG] switch_pgsql.c:415 Query (select hostname from nat) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.145371 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "nat" does not exist</span></p><p class=""><span class="">LINE 1: select hostname from nat</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.145951 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE nat) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.146371 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "nat" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.147824 [DEBUG] switch_pgsql.c:415 Query (delete from registrations where reg_user='') returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.148176 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "registrations" does not exist</span></p><p class=""><span class="">LINE 1: delete from registrations where reg_user=''</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.148623 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE registrations) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.148962 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "registrations" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.152717 [DEBUG] switch_pgsql.c:415 Query (select hostname from recovery) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.153209 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "recovery" does not exist</span></p><p class=""><span class="">LINE 1: select hostname from recovery</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.153622 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE recovery) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.153949 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "recovery" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.162491 [DEBUG] switch_pgsql.c:415 Query (create index recovery3 on recovery(runtime_uuid)) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.163004 [DEBUG] switch_pgsql.c:415 Query (select call_uuid, read_bit_rate, sent_callee_name, initial_cid_name, initial_cid_num, initial_ip_addr, initial_dest, initial_dialplan, initial_context from channels) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.163190 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "channels" does not exist</span></p><p class=""><span class="">LINE 1: ...nitial_dest, initial_dialplan, initial_context from channels</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.163558 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE channels) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.163843 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "channels" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.167943 [DEBUG] switch_pgsql.c:415 Query (select call_uuid from calls) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.168897 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "calls" does not exist</span></p><p class=""><span class="">LINE 1: select call_uuid from calls</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.169869 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE calls) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.170186 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "calls" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.172855 [DEBUG] switch_pgsql.c:415 Query (select * from basic_calls where sent_callee_name='') returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.173239 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "basic_calls" does not exist</span></p><p class=""><span class="">LINE 1: select * from basic_calls where sent_callee_name=''</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.173682 [DEBUG] switch_pgsql.c:415 Query (DROP VIEW basic_calls) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.174007 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: view "basic_calls" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.178108 [DEBUG] switch_pgsql.c:415 Query (select * from detailed_calls where sent_callee_name='') returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.178625 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "detailed_calls" does not exist</span></p><p class=""><span class="">LINE 1: select * from detailed_calls where sent_callee_name=''</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.179041 [DEBUG] switch_pgsql.c:415 Query (DROP VIEW detailed_calls) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.179225 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: view "detailed_calls" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.183253 [DEBUG] switch_pgsql.c:415 Query (select ikey from interfaces) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.184367 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "interfaces" does not exist</span></p><p class=""><span class="">LINE 1: select ikey from interfaces</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.184798 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE interfaces) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.185094 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "interfaces" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.188082 [DEBUG] switch_pgsql.c:415 Query (select task_id, task_desc, task_group, task_runtime, task_sql_manager, hostname from tasks) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.188535 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: relation "tasks" does not exist</span></p><p class=""><span class="">LINE 1: ...k_group, task_runtime, task_sql_manager, hostname from tasks</span></p><p class=""><span class=""> ^</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.189027 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE tasks) returned PGRES_FATAL_ERROR</span></p><p class=""><span class="">2015-12-27 15:21:41.189357 [ERR] switch_pgsql.c:656 Error executing query:</span></p><p class=""><span class="">ERROR: table "tasks" does not exist</span></p><p class=""><span class=""></span><br class=""></p><p class=""><span class="">2015-12-27 15:21:41.248531 [INFO] switch_core_sqldb.c:1693 CORE Starting SQL thread.</span></p></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">And its automatically fallback to SQLlite</div><div class=""> </div><div class=""> </div></div>
_________________________________________________________________________<br class="">Professional FreeSWITCH Consulting Services: <br class=""><a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">http://www.freeswitchsolutions.com<br class=""><br class="">Official FreeSWITCH Sites<br class="">http://www.freeswitch.org<br class="">http://confluence.freeswitch.org<br class="">http://www.cluecon.com<br class=""><br class="">FreeSWITCH-users mailing list<br class="">FreeSWITCH-users@lists.freeswitch.org<br class="">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br class="">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br class="">http://www.freeswitch.org</div></blockquote></div><br class=""></div></body></html>