I think David and I agree on these two basic points regarding mod_xml_curl:
You can validate/manipulate/massage the data prior to insertion

It's uncomplicated, flexible, and reliable

As for connection pooling I'll have to defer to those who use mod_cdr_pg_csv.

-MC

On Tue, Jan 13, 2015 at 11:33 PM, John Nash <john.nash778@gmail.com> wrote:

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

_________________________________________________________________________
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