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?

On Dec 27, 2015, at 10:28 AM, Murugan Pandian <manpower13.cse@gmail.com> wrote:

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
 
 
_________________________________________________________________________
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