Hi Roger, On 10 August 2011 19:18, Friedman, Roger (CDC/CGH/DGHA) (CTR) <[email protected]>wrote:
> So please don't take your frustrations with Tomcat out on > blameless Postgressors. > Definitely not frustrated about Tomcat or MySQL/Postgres. Wanted to see if we are fine to add those drivers, which are currently not in the dependencies. There are also issues which we will have to support and people will have different problems associated with those databases. If developers use MySQL and will not be able to solve issues with other databases, do we want to take that route?? I understand the reasons you mention and I'm very much supportive to the idea of using multiple databases and giving users that choice. With the issues I listed in the last email, I'm also of the opinion postgres has features that I would like to use and hence work on that ticket. But before I went out and fixed those, I wanted to understand if the patch will be accepted and we want to go ahead with the required changes. --- Regards, Saptarshi PURKAYASTHA My Tech Blog: http://sunnytalkstech.blogspot.com You Live by CHOICE, Not by CHANCE > **** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Saptarshi > Purkayastha > *Sent:* Wednesday, August 10, 2011 8:20 AM > > *To:* [email protected] > *Subject:* Re: [OPENMRS-DEV] Supporting 2 Million Patients**** > > ** ** > > 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 > **** > > ** ** > > ** ** > ------------------------------ > > 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]
