This guide assumes a clean RDS instance has just been created.
-
Setting up PostGIS for RDS
PostGIS is used by some OpenLMIS services to provide better geographical support. Amazon provides a great guide on how to do it under this link. Make sure to execute those instructions in the database containing OpenLMIS schemas, rather than postgres.
-
Adding UUID extension on RDS. Some services require the uuid-ossp extension in order to randomly generate UUIDs in SQL. In order to ensure OpenLMIS works properly with RDS, you need to run the following command to install the extension:
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";