It should probably also be pointed out that I pushed some fixes for core_pgsql support over the past couple days for better handling reconnecting to the DB if it loses connectivity. You will definitely want those fixes in place before you lose connectivity on a real, production server. At this time, I have been able to bounce Postgres over and over about 30 times in my tests without any issues getting reconnected and resuming operations.<div>
<br><br><div class="gmail_quote">On Wed, Nov 7, 2012 at 5:51 PM, William King <span dir="ltr"><<a href="mailto:william.king@quentustech.com" target="_blank">william.king@quentustech.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Mod_lua now is able to take advantage of pgsql native support.<br>
<br>
William King<br>
Senior Engineer<br>
Quentus Technologies, INC<br>
1037 NE 65th St Suite 273<br>
Seattle, WA 98115<br>
Main: <a href="tel:%28877%29%20211-9337" value="+18772119337">(877) 211-9337</a><br>
Office: <a href="tel:%28206%29%20388-4772" value="+12063884772">(206) 388-4772</a><br>
Cell: <a href="tel:%28253%29%20686-5518" value="+12536865518">(253) 686-5518</a><br>
<a href="mailto:william.king@quentustech.com">william.king@quentustech.com</a><br>
<div><div class="h5"><br>
On 11/02/2012 10:25 AM, Ken Rice wrote:<br>
> Hey Guys,<br>
><br>
> There’s some new Database Goodness in the core of FreeSWITCH that can<br>
> lead to some unexpected things for you guys updating existing<br>
> installations using ODBC.<br>
><br>
> We now have Native PostgreSQL support in the core, and along with this<br>
> comes some changes to the various “odbc-dsn” settings around the tree.<br>
><br>
> If you are using the format “dsn:username:password” you wont be<br>
> affected, however if you are just specifying a DSN as “dsn” you will<br>
> need to listen up<br>
><br>
> The settings for this field have changed.<br>
><br>
> pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password=''<br>
> options='-c client_min_messages=NOTICE for postgresql (the stuff after<br>
> pgsql:// is a standard libpq connect string for you programmer types)<br>
> odbc://dns:username:password for ODBC ( dsn:: should also work or<br>
> dns:username: )<br>
> sqlite://filename for sqlite different SQLite Databases<br>
><br>
> I think we still need to doc this up good, but its there and its coming<br>
> strong...<br>
><br>
> --<br>
> Ken<br>
</div></div>> _<a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a><br>
> <a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
> <a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br>
> _<a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<div class="HOEnZb"><div class="h5">><br>
><br>
> _________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Eliot Gable<br><br>"We do not inherit the Earth from our ancestors: we borrow it from our children." ~David Brower <br><br>"I decided the words were too conservative for me. We're not borrowing from our children, we're stealing from them--and it's not even considered to be a crime." ~David Brower<br>
<br>"Esse oportet ut vivas, non vivere ut edas." (Thou shouldst eat to live; not live to eat.) ~Marcus Tullius Cicero<br>
</div>