Bryant Zimmerman
2010-Sep-13 15:47 UTC
[asterisk-users] PostgreSQL is asterisk friendly with it?
As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Is there any down side to PostgreSQL over mySQL or will it be a big win? Our database servers are linux but we access them from asterisk as well as windows are there any thing to be concerned with there? I use c#, vb.net and mono to do a lot of our stuff are there any issues I should know about? Thanks Bryant -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100913/c9aadac1/attachment.htm
Danny Nicholas
2010-Sep-13 15:59 UTC
[asterisk-users] PostgreSQL is asterisk friendly with it?
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Bryant Zimmerman Sent: Monday, September 13, 2010 10:47 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] PostgreSQL is asterisk friendly with it?>As I look to move our systems to version 1.8 I am looking at making achange from mySQL to PostgreSQL.>I love mySQL but am getting very concerned about i'ts new owners. >Should I be able to move all my realtime stuff to PostgreSQL is it fullysupported with asterisk?>Is there any down side to PostgreSQL over mySQL or will it be a big win? >Our database servers are linux but we access them from asterisk as well aswindows are there any thing to be concerned with there?>I use c#, vb.net and mono to do a lot of our stuff are there any issues Ishould know about?>Thanks >BryantIn 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. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100913/95374a0b/attachment.htm
Benny Amorsen
2010-Sep-13 18:24 UTC
[asterisk-users] PostgreSQL is asterisk friendly with it?
"Bryant Zimmerman" <BryantZ at zktech.com> writes:> As I look to move our systems to version 1.8 I am looking at making a > change from mySQL to PostgreSQL. > > I love mySQL but am getting very concerned about i'ts new owners. > Should I be able to move all my realtime stuff to PostgreSQL is it fully > supported with asterisk?Yes. The ODBC drivers don't really care which database you access.> Is there any down side to PostgreSQL over mySQL or will it be a big win?The only issue we have with Postgres is the dump/reload cycle when upgrading database version. This is being fixed in the latest versions though.> Our database servers are linux but we access them from asterisk as well as > windows are there any thing to be concerned with there?It works fine from Windows as well. /Benny