Support For PostgreSQL

these are the current changes needed on top of the latest 1.11.x to install the openmrs-core on Postgresql 9.3:

diff --git a/api/src/main/resources/liquibase-update-to-latest.xml b/api/src/main/resources/liquibase-update-to-latest.xml
index 2e5aab2..62f5998 100644
--- a/api/src/main/resources/liquibase-update-to-latest.xml
+++ b/api/src/main/resources/liquibase-update-to-latest.xml
@@ -7575,7 +7575,7 @@
             <column name="java_class_name" value="org.openmrs.TestOrder" />
             <column name="creator" valueNumeric="1" />
             <column name="date_created" valueDate="2014-03-09" />
-            <column name="retired" valueNumeric="0" />
+            <column name="retired" valueBoolean="false" />
             <column name="uuid" value="52a447d3-a64a-11e3-9aeb-50e549534c5e" />
         </insert>
     </changeSet>
@@ -8313,6 +8313,10 @@
             <column name="date_created" valueDate="2014-03-06"/>
             <column name="retired" valueBoolean="false"/>
         </insert>
+               <!-- Update postgres sequence correctly as it is incorrect after previous inserts with explicit concept_class_id's -->
+               <modifySql dbms="postgresql">
+                       <prepend value="SELECT setval('concept_class_concept_class_id_seq', (SELECT MAX(concept_class_id) FROM concept_class)+1);"/>
+               </modifySql>
     </changeSet>
 
     <changeSet id="20140304816-TRUNK-4139" author="Akshika">

I just briefly tested in the UI. Was able to login, create a patient :slight_smile:

I have installed the OpenMRS without demo data. This is the next place I would look for issues.

How should we proceed? Is anybody else also going to test as well? Should I create a PR, if I get it to install also without the demo data?

2 Likes