Component description

PostgreSQL has become the preferred open source relational database for many enterprise developers and start-ups, powering leading business and mobile applications. The component is is available in two major manifestations. Both supports backups, software patching, monitoring, scaling and replication.

• PostgreSQL Standard: The well-know traditional PostgreSQL-Engine makes it easy to use and scale PostgreSQL in cloud environments.

• PostgreSQL Aurora: A PostgreSQL-compatible database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. It is up to three times faster than standard PostgreSQL databases. Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 128TB per database instance. It delivers high performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).

Variants

PostgreSQL Standard

• Single: 1 Node

• Fail-Over: 1 Node + 1 Fail-Over Node (Multi-AZ)

• Cluster: 1 Node + 1 Fail-Over Node (Multi-AZ) + 1 ReadReplica)

PostgreSQL Aurora

• Single: Cluster with 1 Node

• Fail-Over: Cluster with 1 Writer and 1 Reader

• Autoscaling: Cluster with 1 Writer and 1 Reader and Autoscaling active

• Serverless

Currently supported versions

The latest versions and further information can be found here:

• https://aws.amazon.com/rds/postgresql/faqs/

• https://aws.amazon.com/rds/aurora/faqs/

Pricing

For AWS pricing see https://aws.amazon.com/rds/pricing/.

For root360 Managed Services pricing please contact our Service Team.

Related tutorials