PostgreSQL is an open-source object-relational database management system with an emphasis on extensibility and standards compliance. It applies to business-oriented online transaction processing (OLTP) scenarios and supports NoSQL (JSON, XML, or HStore) and geographic information system (GIS) data types.
RDS supports PITR of your database.
Easy to Scale
RDS supports data synchronization within seconds and responds to scaling requests quickly. In addition, you can create read replicas and change the CPU/memory to meet your service requirements.
RDS supports one primary and multiple standby DB instances, read/write splitting, primary/standby switchover, high concurrency, and high availability.
RDS enhances PostgreSQL spatial features and supports geospatial, raster, and vector data.