I tried running xTuple on AWS RDS postgres and ran into a couple of problems, both related to the need for a superuser on the database. AWS RDS does not allow one to create a super-user because they are taking responsibility for backups and server maintenance, and it also reserves the username "admin". It is possible to create a new user, but not with super user capabilities, or named admin. I think this is pretty common in shared hosting scenarios.
Because the userpriv tables are hardcoded to only give permissions to 'admin" we can't start with a clean database.
I'd like to use RDS due to the automated backups/failover and the fact that I can access it from anywhere. If I restore a database from my local machine to the RDS service that has the username and permissions defined that I want, am I going to run into issues with not having full super-user privileges?
Most of the previous database applications I've used use one set of credentials for connecting to the database, and a different set that handles application level authentication and authorization. Are there any plans to decouple the database user from the applicaton user?