From January 2013 all ManageEngine products will have PostgreSQL, version 9.2 as the default backend database instead of MySQL.
Reason for switching to PostgreSQL
At ManageEngine we have always tried to make it easy for users to trial and run our products. We made sure that users who downloaded and installed our products could get started in minutes as we bundled everything that was needed to run the product. Over the past decade we were able to deliver that with MySQL.
Now, over the years, PostgreSQL too evolved well as a credible RDBMS. BTW PostgreSQL has some promising engineering features like high availability, data replication and reporting capabilities. These looked interesting. That along with the events at MySQL AB in the last few years are the primary reasons for us to shift our bundled database from MySQL to PostgreSQL.
We believe this move will benefit our customers and the products in the long run.
We like to reiterate that ManageEngine is thrilled to work with you through 2013 to help you with your IT management problems.
PostgreSQL is an enterprise class, powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX, and Windows. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. To know more on the feature matrix, click here.
MySQL vs. PostgreSQL
Honestly, both MySQL and PostgreSQL are good DBMS. However, each varies in performance with respect to the environment they are used. We have tested our products with both PostgreSQL & MySQL and got similar results. Also there is no difference in the product performance. The detailed comparison matrix for each product will be released later.
What it is for existing Customers?
Existing users can continue with the product as it is. You don’t have to migrate your DB to PostgreSQL because all the upcoming service packs and hotfixes will support MySQL, MS SQL (if supported earlier) and PostgreSQL If you wish to migrate to PostgreSQL, contact our support team. They will help you with the migration.
Report Issues with PostgreSQL Installation
If you overcome any issues during the installation or thereafter, you can report them by filling this form. Our support team will help you at the earliest.
I’m an existing user. Do I have to migrate to PostgreSQL?
Not necessary, you can still continue with MySQL. However, down the line we might ask you to migrate.
How to migrate to PostgreSQL?
Right now we don’t encourage users to migrate to PostgreSQL. However, you can contact the respective support teams to know the procedure.
Do I have to pay anything extra for PostgreSQL?
No. Its license cost is already covered in the product.
Is it possible to migrate from PostgreSQL to MSSQL in the future?
Yes. That should be possible. We will announce the migration once it is ready.
Can I install SwissSQL on the same server that has the ManageEngine product already deployed?
Yes, provided the system requirements of both the products are met.