This page is for documenting PostgreSQL Database Support as the Main Data store.
Child Pages- Postgres Configuration
- Data Model ER Diagram
- Data migration from CouchDb
- How to add/edit/remove a table/column
- Testing
- Tips and Tricks
- Hashing of OpenSRP data
OpenSRP supports using Postgres as the primary datastore(database) for storing OpenSRP data. OpenSRP supports using either CouchDb or Postgres as the primary database; only one can be enabled at a time.
...
To build with Postgres use
mvn clean install package -Dopensrp.database.type=postgres or
mvn clean install clean package -P postgres
To build with CouchDB
mvn clean install clean package -Dopensrp.database.type=couchdb Or
mvn clean install clean package -P couchdb