Hello David and Michael, As per this page https://freeswitch.org/confluence/display/FREESWITCH/mod_cdr_pg_csv we can define disk spooling in case of insert failure. What are the other advantages of xml_cdr over cdr_pg_csv? Also does cdr_pg_csv use connection pooling? Regards Manoj On Wed, Jan 14, 2015 at 9:05 AM, David Villasmil Govea < david.villasmil@gmail.com> wrote:
You can even do the billing with it... I've had it running in production for years, not a single issue... Is it an absolute requirement to log directly to the database? There has been thorough and intense discussion on this list over the years as to why this is/isn't a good idea. IMHO the best option is to use mod_xml_cdr (see https://wiki.freeswitch.org/wiki/Mod_xml_cdr). It lets you post to a database and store on disk in case of failure. It's also pretty easy to use and lets you do logic/validation prior to storing in the db.
-MC
On Sat, Jan 10, 2015 at 12:33 PM, Nick Zaitsev <nick.zaitsev@mail.ru> wrote:
Good day to you, Please,advise me, how can i use postgres schema in freeswitch config (cdr_pg_csv.conf.xml)? I'd like to use cdr schema instead public, for example here <param name="db-info" value="host=localhost dbname=freeswitch connect_timeout=10" />
-- Nick Zaitsev
_________________________________________________________________________ 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
_________________________________________________________________________ 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
_________________________________________________________________________ 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