Return to Jive Software

Skip navigation
Up to Discussions in Support
830 Views 3 Replies Last post: Aug 6, 2009 12:39 PM by sean.moran RSS
bdavis Novice
bdavis
230 posts since
Feb 20, 2003
Currently Being Moderated

Aug 6, 2009 12:07 PM

MySQL or PostgreSQL?

Currently we are on Clearspace 2.5.9 and MySQL. When we upgrade to SBS do you recommend that we switch to PostgreSQL?

I know we don't have to switch since MySQL is supported, but which way will be less trouble in the long run with future upgrades

and support in general from Jivesoftware? Thanks.

Tags: mysql, postgresql
sean.moran Jive Employee
sean.moran
7,757 posts since
Dec 10, 2007
Currently Being Moderated
Aug 6, 2009 12:16 PM in response to: Ben Davis
Re: MySQL or PostgreSQL?

Hi Ben,

 

Both MySQL and PostgreSQL are equally supported. Since you're on MySQL already, it would be much easier to upgrade to Jive SBS with MySQL. Switching to PostgreSQL would require you to go through a database migration first, requiring additional configuration steps.

 

In short, unless you need to move to PostgreSQL for another reason, you'll be just fine on MySQL.

bdavis Novice
bdavis
230 posts since
Feb 20, 2003
Currently Being Moderated
Aug 6, 2009 12:36 PM in response to: Sean Moran
Re: MySQL or PostgreSQL?
Thanks Sean. In that case, I'll stick with MySQL.
sean.moran Jive Employee
sean.moran
7,757 posts since
Dec 10, 2007
Currently Being Moderated
Aug 6, 2009 12:39 PM in response to: Ben Davis
Re: MySQL or PostgreSQL?
Sounds good, Ben. Let us know if you have any additional questions.

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.