RDS can be Postgres, but isn't always. You can choose from MySQL, SQL Server, Oracle and Postgres, but Postgres support is currently in beta [1].

[1]: https://aws.amazon.com/rds/postgresql/