Thank you for writing question. Many of people come across similar query now days. I'll also add some general overview about concept of RDS.
RDS stands for Remote Database Services. Here, database would be available as service rather infrastructure. In other words, database port and global host name would be available. Server access via ssh/rdp is not allowed. Management/maintenance of server(s) would be managed by vendor(Amazon). Amazon RDS is a part of low-cost services, when a customer doesn't wish to manage infrastructure.
There are certain limitations of using Amazon RDS.
1) Amazon RDS doesn't provide super user access to the environment. So, admin level operations are restricted to user. However, certain required privileges are provisioned via rds database user.
2) For major upgrade, Amazon RDS provides upgrade to immediate next version. One may not upgrade to next second or third major version. e.g. 9.3 -> 9.6 is not allowed. But, 9.3 -> 9.4 is allowed.
3) Table space creation is not feasible as We don't have access to file system.
4) For PostgreSQL extensions, only certain pre-configured extensions can be installed. Extensions which are not configured can'b be installed. e.g. plpythonu
5) Access to pg_hba.conf is not provisioned. This needs to taken care through security groups.
Thanks & Regards,
... View more