[Freeswitch-users] postgresql

[Michael Collins]

Also, most web servers are designed to handle many multiple requests. If
you have a robust web server/db backend then you can scale as needed and do
failover, etc.

-MC

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

> OK I see the point of manipulating CDR data (Even bill CDR as you said). I
> am just trying to figure out best approach. But I also see a downside of
> http post as it will keep web server busy too for each call made specially
> in high volume systems (Assuming user portal/reporting also are being used
> on same web server)
>
> On the other hand if pg_cdr module is used with postgres function we can
> manipulating CDR too without keeping web server busy.
>
>
>
>
>
> On Wed, Jan 14, 2015 at 1:15 PM, Michael Collins <msc at freeswitch.org>
> wrote:
>
>> 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150114/bd46bbae/attachment.html