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
163 companies use Amazon RDS for PostgreSQL in their tech stacks, including Netflix, Instacart, and Obama for America Campaign 2012.

Developers
27 developers use Amazon RDS for PostgreSQL.

Amazon RDS for PostgreSQL Integrations

Redash, Stitch, AWS Glue, Backand, and AWS Secrets Manager are some of the popular tools that integrate with Amazon RDS for PostgreSQL. Here's a list of all 9 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 ElastiCache
Amazon Elasticsearch Service
AWS Elastic Load Balancing (ELB)
Memcached
Redis
Python
AWS Lambda
Amazon RDS
Microsoft SQL Server
MariaDB
Amazon RDS for PostgreSQL
Rails
Ruby
Heroku
AWS Elastic Beanstalk

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 · 2.3K views
atChilli
Arch Linux
Amazon EC2
PostgreSQL
Amazon RDS for PostgreSQL

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
PostgreSQL
Amazon DynamoDB
Amazon RDS for 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 · 801 views
atFramework Science
Amazon DynamoDB
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

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

See more
Dieter Vekeman
Dieter Vekeman
Developer at Tinkhaven · | 1 upvotes · 182 views
atTinkhaven
Amazon RDS for PostgreSQL

Hosting the main relational DB engine

  • Scalable
  • Accessed by the backend (AWS EC2)
  • Automatic minor upgrades
  • Automated daily backups

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 Stats

- No public GitHub repository available -
No Stats