What is Amazon RDS for PostgreSQL?
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.
Amazon RDS for PostgreSQL is a tool in the PostgreSQL as a Service category of a tech stack.
Who uses Amazon RDS for PostgreSQL?
Companies
332 companies reportedly use Amazon RDS for PostgreSQL in their tech stacks, including Netflix, Amazon, and Instacart.
Developers
454 developers on StackShare have stated that they use Amazon RDS for PostgreSQL.
Amazon RDS for PostgreSQL Integrations
Amazon DynamoDB, Liquibase, AWS Glue, GoLand, and Redash are some of the popular tools that integrate with Amazon RDS for PostgreSQL. Here's a list of all 16 tools that integrate with Amazon RDS for PostgreSQL.
Pros of Amazon RDS for PostgreSQL
25
13
2
Decisions about Amazon RDS for PostgreSQL
Here are some stack decisions, common use cases and reviews by companies and developers who chose Amazon RDS for PostgreSQL in their tech stack.
StackShare Editors
From a StackShare Community member: "We’re debating going with Amazon RDS for PostgreSQL or Amazon DynamoDB. Cost is our main concern but we’re also curious about other potential benefits/differences. Which one would you recommend and why?"
Blog Posts
+8 6
2758
+42 49
40926
+47 55
72779
+39 22
31754
+26 15
5425
+35 13
1790
Amazon RDS for PostgreSQL's Features
- 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
Amazon RDS for PostgreSQL Alternatives & Comparisons
What are some alternatives to Amazon RDS for PostgreSQL?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, user-defined types
and functions.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
Redis
Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.
Amazon S3
Amazon Simple Storage Service provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the web
