<div dir="ltr">Hi,<div><br></div><div> 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><br></div><div>
<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><p class=""><span class=""></span></p>
<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><p class=""><span class=""></span></p>
<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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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></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><br></div><div><br></div><div>And its automatically fallback to SQLlite</div><div> </div><div> </div></div>