I was looking through this discussion and wanted to know how much of a priority is it for the community to run OpenMRS on Postgres or MSSQL?? Other than once-in-a-while mails on the dev list?? Is it our core motivation to have users choose what database they want OpenMRS to work on?? It is some amount of work (upgrading liquibase is definitely required, adding database drivers and changing mysql-specific - tinyint to smallint, longtext etc.).
Also among other things, I've yesterday had problems with simultaneous users (75+) using the system (16GB+ server) and getting out of memory and having to restart the system every 12-14hrs to release memory. The memory usage goes on increasing for Tomcat and restarting the server seems like the simple solution for the time being. I've heard Paul talk about a similar problem at AMPATH in one of the conf call recordings. Has there been a workaround at AMPATH or is restarting Tomcat the accepted solution?? I'm planning to host OpenMRS on Glassfish (with its better monitoring tools and VisualVM integration) and also write a performance monitoring module that uses javamelody <http://code.google.com/p/javamelody/>, but any suggestions in the meantime should be useful... --- Regards, Saptarshi PURKAYASTHA My Tech Blog: http://sunnytalkstech.blogspot.com You Live by CHOICE, Not by CHANCE On 27 July 2011 18:18, Ben Wolfe <[email protected]> wrote: > I think this was the ticket I was thinking of: > https://tickets.openmrs.org/browse/TRUNK-1925 > > That ticket should be edited to be more general about supporting all > databases. The removal of the "not exists" from the wizard is just one part > of that. > > The openmrs app does run on everything. And I'm pretty sure the update > wizard / liquibase changesets run on everything. So a quick fix would be to > install to mysql, then export the database tables and import those into > postgresql. > > Ben > > On Wed, Jul 27, 2011 at 1:44 PM, Suranga Kasthurirathne < > [email protected]> wrote: > >> >> Hi, >> >> >> Looks like you could do with an Openmrs Id, >> >> go to https://wiki.openmrs.org/display/RES/OpenMRS+ID, and create your >> id, this will let you interact (and yes, create tickets) easily. >> once you create an id, you can use it to log in, and use JIRA. >> >> after signing in, go to https://tickets.openmrs.org/secure/Dashboard.jspa and >> click on 'create issue' (on the top right of screen). >> >> Hope this helps. >> >> >> >> >> On Wed, Jul 27, 2011 at 4:04 PM, Sokha RUM <[email protected]> wrote: >> >>> I look for the existing ticket, and i found a ticket TRUNK-1922 which is >>> about the supporting 6 types of database including also PostgreSQL. But >>> that >>> ticket is already in status "Fixed". >>> >>> One more thing i wanted to create a new ticket, but could not login. I do >>> not know if i can use the account for joining community to access to >>> ticket >>> of OpenMRS. >>> >>> _________________________________________ >>> >>> To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to >>> [email protected] with "SIGNOFF openmrs-devel-l" in the body >>> (not the subject) of your e-mail. >>> >>> [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l] >>> >> >> >> >> -- >> Best Regards, >> >> Suranga >> >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >> OpenMRS Developers' mailing list > > > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
