Amazon RDS for PostgreSQL logo

Amazon RDS for PostgreSQL

Set up, operate, and scale PostgreSQL deployments in the cloud
421
198
+ 1
37

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
237 companies reportedly use Amazon RDS for PostgreSQL in their tech stacks, including Netflix, Instacart, and Product Hunt.

Developers
168 developers on StackShare have stated that they use Amazon RDS for PostgreSQL.

Amazon RDS for PostgreSQL Integrations

Amazon DynamoDB, Redash, Stitch, Backand, and SignalFx are some of the popular tools that integrate with Amazon RDS for PostgreSQL. Here's a list of all 10 tools that integrate with Amazon RDS for PostgreSQL.

Why developers like Amazon RDS for PostgreSQL?

Here’s a list of reasons why companies and developers use Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL Reviews

Here are some stack decisions, common use cases and reviews by companies and developers who chose Amazon RDS for PostgreSQL in their tech stack.

Amazon EC2
Amazon EC2
PostgreSQL
PostgreSQL
Amazon EBS
Amazon EBS
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
Heroku Postgres
Heroku Postgres
Amazon RDS
Amazon RDS

I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

See more
AWS Elastic Beanstalk
AWS Elastic Beanstalk
Heroku
Heroku
Ruby
Ruby
Rails
Rails
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
MariaDB
MariaDB
Microsoft SQL Server
Microsoft SQL Server
Amazon RDS
Amazon RDS
AWS Lambda
AWS Lambda
Python
Python
Redis
Redis
Memcached
Memcached
AWS Elastic Load Balancing (ELB)
AWS Elastic Load Balancing (ELB)
Amazon Elasticsearch Service
Amazon Elasticsearch Service
Amazon ElastiCache
Amazon ElastiCache

We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

See more
Pierre Chapuis
Pierre Chapuis
at Pierre Chapuis · | 5 upvotes · 6.8K views
atChilliChilli
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
PostgreSQL
PostgreSQL
Amazon EC2
Amazon EC2
Arch Linux
Arch Linux

We use AWS mostly because Amazon RDS for PostgreSQL is a very good and cheap solution to get a managed PostgreSQL.

We also use Amazon EC2 for the servers, with the Arch Linux images from Uplink Labs. We chose Arch Linux because of its up-to-date packages, especially for Python. We use Pacman to package and deploy our services.

See more
Fábio Augusto Falavinha
Fábio Augusto Falavinha
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
Amazon DynamoDB
Amazon DynamoDB
PostgreSQL
PostgreSQL

Amazon RDS for PostgreSQL or Amazon DynamoDB? If you need to follow RDBS concepts choose Amazon RDS (PostgreSQL). This choice will guarantee a stable relational database with a great support for years from PostgreSQL Global Development Group. But, you need a great scalable NoSQL database. You can use Amazon DynamoDB. The most important thing about this is that you can use RESTful HTTP API to access data.

See more
FWScience
FWScience
| 4 upvotes · 3.9K views
atFramework ScienceFramework Science
Amazon DynamoDB
Amazon DynamoDB
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL

We use Amazon RDS for PostgreSQL because RDS and Amazon DynamoDB are two distinct database systems. DynamoDB is NoSQL DB whereas RDS is a relational database on the cloud. The pricing will mainly differ in the type of application you are using and your requirements. For some applications, both DynamoDB and RDS, can serve well, for some it might not. I do not think DynamoDB is cheaper. Right now we are helping Companies in Silicon Valley and in Southern California go SERVERLESS - drastically lowering costs if you are interested in hearing how we go about it.

See more
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL

Using PostGIS to serve GeoJSON data for the Leaflet front-end. Amazon RDS for PostgreSQL

See more

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?
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.
Google Cloud SQL for PostgreSQL
Cloud SQL offers high performance, scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.
Azure Database for PostgreSQL
Azure Database for PostgreSQL provides a managed database service for app development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most.
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.
Database Labs
We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
See all alternatives

Amazon RDS for PostgreSQL's Followers
198 developers follow Amazon RDS for PostgreSQL to keep up with related blogs and decisions.
Paul Dandurand
TYG1
War Dah
Nurullah Özdemir
Simon Rascovsky
Dien Phan
Srdan Srepfler
heejoun lee
Sajjad vafaie
Alvin Savoy