RDS configurationΒΆ

This guide assumes a clean RDS instance has just been created.

  1. 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.

  2. 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";