On Mon, 13 Sep 2010, Danny Nicholas wrote: > From: asterisk-users-boun...@lists.digium.com > [mailto:asterisk-users-boun...@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 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 > > 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.
Say what? I just looked at the 1.4 sources and PostgreSQL is NOT supported as ODBC. Those are direct library calls into libpq. Bryant, I've been using PostgreSQL with asterisk since I started using asterisk a number of years ago. There have been exactly ZERO issues with it. Vince. -- Michigan VHF Corp. http://www.nobucks.net/ http://www.CDupe.com/ -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users