RDS Postgres, Aurora Postgres, or Local Postgres database?

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    ** 7.9
  • what are you trying to achieve
    ** New setup/install and looking for best practice
  • what have you tried so far to achieve this
    ** Stood up new EC2 instance with Bitnami AMI. Currently it is using a local Postgres 10 database.

We are a small company that will be using Sonarqube. My goal is to make it easy to upgrade Sonarqube when new versions are released. To that end, would it be best to use the local Postgres 10 database or to use RDS or Aurora Postgresql?

Thank You!

We always recommend hosting the database server separately from the application server.

While we don’t specifically test any AWS flavors of Postgres, I have seen a number of users elect to use Aurora/RDS and have any issues. Just make sure you use a flavor compatible with the versions of Postgres we declare Compatability for. For example, I understand it’s possible to use AWS RDS explicitly compatible with Postgres 10.

1 Like