Lonnie
CEO - Co-founder US, Mexico Binational Tech Start-up Accelerator, Incubator at Framework Science
May 9, 2019
9.18k views9.18k
CommentsAmazon RDS vs Amazon RDS for PostgreSQL
Overview
Share your Stack
Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.
CLI (Node.js)
Manual
Advice on Amazon RDS, Amazon RDS for PostgreSQL
Detailed Comparison
Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call. | Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS. |
Pre-configured Parameters;Monitoring and Metrics;Automatic Software Patching;Automated Backups;DB Snapshots;DB Event Notifications;Multi-Availability Zone (Multi-AZ) Deployments;Provisioned IOPS;Push-Button Scaling;Automatic Host Replacement;Replication;Isolation and Security | Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.;DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.;Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.;Automated Backups – Turned on by default, the automated backup feature of Amazon RDS enables point-in-time recovery for your DB Instance.;DB Snapshots – DB Snapshots are user-initiated backups of your DB Instance.;Pre-configured Parameters – Amazon RDS for PostgreSQL deployments are pre-configured with a sensible set of parameters and settings appropriate for the DB Instance class you have selected.;PostGIS;Language Extensions :PL/Perl, PL/pgSQL, PL/Tcl;Full Text Search Dictionaries;Advanced Data Types : HStore, JSON;Core PostgreSQL engine features |
Statistics | |
Stacks 16.2K | Stacks 814 |
Followers 10.8K | Followers 607 |
Votes 761 | Votes 40 |
Pros & Cons | |
Pros
| Pros
|
What are some alternatives to Amazon RDS, Amazon RDS for PostgreSQL?
Amazon Aurora
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.
Google Cloud SQL
Run the same relational databases you know with their rich extension collections, configuration flags and developer ecosystem, but without the hassle of self management.
Heroku Postgres
Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
ClearDB
ClearDB uses a combination of advanced replication techniques, advanced cluster technology, and layered web services to provide you with a MySQL database that is "smarter" than usual.
ElephantSQL
ElephantSQL hosts PostgreSQL on Amazon EC2 in multiple regions and availability zones. The servers are continuously transferring the Write-Ahead-Log (the transaction log) to S3 for maximum reliability.
Azure SQL Database
It is the intelligent, scalable, cloud database service that provides the broadest SQL Server engine compatibility and up to a 212% return on investment. It is a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software.
Database Labs
We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
Cloud DB for Mysql
It is a fully managed cloud cache service that enables you to easily configure a MySQL database with a few settings and clicks and operate it reliably with NAVER's optimization settings, and that automatically recovers from failures.
Google Cloud SQL for PostgreSQL
With Cloud SQL for PostgreSQL, you can spend less time on your database operations and more time on your applications.
PlanetScaleDB
It is a fully managed cloud native database-as-a-service built on Vitess and Kubernetes. A MySQL compatible highly scalable database. Effortlessly deploy, manage, and monitor your databases in multiple regions and across cloud providers.
