<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] <b><span style='font-weight:
bold'>On Behalf Of </span></b>Bryant Zimmerman<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, September 13, 2010
10:47 AM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Asterisk
Users Mailing List - Non-Commercial Discussion</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> [asterisk-users]
PostgreSQL is asterisk friendly with it?</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>></span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>As I look to
move our systems to version 1.8 I am looking at making a change from mySQL to
PostgreSQL.<br>
<br>
<font color=navy><span style='color:navy'>></span></font>I love mySQL but am
getting very concerned about i'ts new owners. <br>
<font color=navy><span style='color:navy'>></span></font>Should I be able to
move all my realtime stuff to PostgreSQL is it fully supported with asterisk?<br>
<font color=navy><span style='color:navy'>></span></font>Is there any down
side to PostgreSQL over mySQL or will it be a big win?<br>
<font color=navy><span style='color:navy'>></span></font>Our database
servers are linux but we access them from asterisk as well as windows are there
any thing to be concerned with there?<br>
<font color=navy><span style='color:navy'>></span></font>I use c#, vb.net
and mono to do a lot of our stuff are there any issues I should know about?<br>
<br>
<font color=navy><span style='color:navy'>></span></font>Thanks<br>
<font color=navy><span style='color:navy'>></span></font>Bryant<font
color=navy><span style='color:navy'><o:p></o:p></span></font></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>In my
experience, Asterisk plays much more nicely with MYSQL than POSTGRESQL.
PostgreSQL is “supported” as ODBC vs “NATIVE” support
for MYSQL. The “downside” that I’m aware of is that
certain features of MYSQL aren’t directly portable to PostgreSQL (blobs
for example). Linux could care less. IMO, Asterisk will be a larger
hurdle than C#, vb.net or mono to jump over. This is all in 1.4/1.6; some
changes may have modified these answers regarding 1.8.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><br>
<br>
<o:p></o:p></span></font></p>
<div id=divSignature>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>