[Freeswitch-users] Freeswitch Postgres Core

[Murugan Pandian]

Hi,

     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

2015-12-27 15:21:41.131713 [INFO] switch_core_sqldb.c:3381 Opening DB

2015-12-27 15:21:41.132636 [DEBUG] switch_pgsql.c:415 Query (delete from
channels where hostname='debian-jessie') returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.133062 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "channels" does not exist

LINE 1: delete from channels where hostname='debian-jessie'

     2015-12-27 15:21:41.133614 [DEBUG] switch_pgsql.c:415 Query (delete
from calls where hostname='debian-jessie') returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.133983 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "calls" does not exist

LINE 1: delete from calls where hostname='debian-jessie'

                    ^

2015-12-27 15:21:41.134455 [DEBUG] switch_pgsql.c:415 Query (delete from
tasks where hostname='debian-jessie') returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.135202 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "tasks" does not exist

LINE 1: delete from tasks where hostname='debian-jessie'

                    ^


2015-12-27 15:21:41.135612 [DEBUG] switch_pgsql.c:415 Query (select
hostname from aliases) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.135955 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "aliases" does not exist

LINE 1: select hostname from aliases

                             ^


2015-12-27 15:21:41.136424 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
aliases) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.136764 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "aliases" does not exist


2015-12-27 15:21:41.140727 [DEBUG] switch_pgsql.c:415 Query (select
hostname from complete) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.141003 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "complete" does not exist

LINE 1: select hostname from complete

                             ^


2015-12-27 15:21:41.141602 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
complete) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.141952 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "complete" does not exist


2015-12-27 15:21:41.145120 [DEBUG] switch_pgsql.c:415 Query (select
hostname from nat) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.145371 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "nat" does not exist

LINE 1: select hostname from nat

                             ^


2015-12-27 15:21:41.145951 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
nat) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.146371 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "nat" does not exist


2015-12-27 15:21:41.147824 [DEBUG] switch_pgsql.c:415 Query (delete from
registrations where reg_user='') returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.148176 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "registrations" does not exist

LINE 1: delete from registrations where reg_user=''

                    ^


2015-12-27 15:21:41.148623 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
registrations) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.148962 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "registrations" does not exist


2015-12-27 15:21:41.152717 [DEBUG] switch_pgsql.c:415 Query (select
hostname from recovery) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.153209 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "recovery" does not exist

LINE 1: select hostname from recovery

                             ^


2015-12-27 15:21:41.153622 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
recovery) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.153949 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "recovery" does not exist


2015-12-27 15:21:41.162491 [DEBUG] switch_pgsql.c:415 Query (create index
recovery3 on recovery(runtime_uuid)) returned PGRES_FATAL_ERROR

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

2015-12-27 15:21:41.163190 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "channels" does not exist

LINE 1: ...nitial_dest, initial_dialplan, initial_context from channels

                                                               ^


2015-12-27 15:21:41.163558 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
channels) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.163843 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "channels" does not exist


2015-12-27 15:21:41.167943 [DEBUG] switch_pgsql.c:415 Query (select
call_uuid from calls) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.168897 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "calls" does not exist

LINE 1: select call_uuid from calls

                              ^


2015-12-27 15:21:41.169869 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
calls) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.170186 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "calls" does not exist


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

2015-12-27 15:21:41.173239 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "basic_calls" does not exist

LINE 1: select * from basic_calls where sent_callee_name=''

                      ^


2015-12-27 15:21:41.173682 [DEBUG] switch_pgsql.c:415 Query (DROP VIEW
basic_calls) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.174007 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  view "basic_calls" does not exist


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

2015-12-27 15:21:41.178625 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "detailed_calls" does not exist

LINE 1: select * from detailed_calls where sent_callee_name=''

                      ^


2015-12-27 15:21:41.179041 [DEBUG] switch_pgsql.c:415 Query (DROP VIEW
detailed_calls) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.179225 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  view "detailed_calls" does not exist


2015-12-27 15:21:41.183253 [DEBUG] switch_pgsql.c:415 Query (select ikey
from interfaces) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.184367 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "interfaces" does not exist

LINE 1: select ikey from interfaces

                         ^


2015-12-27 15:21:41.184798 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
interfaces) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.185094 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "interfaces" does not exist


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

2015-12-27 15:21:41.188535 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  relation "tasks" does not exist

LINE 1: ...k_group, task_runtime, task_sql_manager, hostname from tasks

                                                                  ^


2015-12-27 15:21:41.189027 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE
tasks) returned PGRES_FATAL_ERROR

2015-12-27 15:21:41.189357 [ERR] switch_pgsql.c:656 Error executing query:

ERROR:  table "tasks" does not exist


2015-12-27 15:21:41.248531 [INFO] switch_core_sqldb.c:1693 CORE Starting
SQL thread.


And its automatically fallback to SQLlite
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20151227/eaae5888/attachment-0001.html