RDS configuration

Setting up PostGIS for RDS

If you want to add PostGIS support to your database you need to do some setting up. 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. You may also need to set correct search paths to the schemas you are installing the extensions in and reconnect to the database, depending on the way you are installing them.

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 may need to run the following command to install the extension:

CREATE EXTENSION "uuid-ossp";