#Aws postgresql how to#

RDS is available on several database instance types - optimized for memory, performance, or I/O.Īmazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Amazon RDS for PostgreSQLĪccording to Amazon, Amazon Relational Database Service (RDS) provides six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server. PostgreSQL runs on all major operating systems and has been ACID-compliant since 2001. PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility. Originating at UC Berkeley in 1986, PostgreSQL has more than 30 years of active core development. PostgreSQLĪccording to its website, PostgreSQL, commonly known as Postgres, is the world’s most advanced Open Source relational database. The primary technologies used in this post include the following. Once running, we will examine a variety of methods to interact with our database instances, including pgAdmin, Adminer, and Python. Amazon RDS Event Notifications will send text messages to our mobile device to let us know when the RDS instances are ready for use. AWS Systems Manager Parameter Store will be used to store our CloudFormation configuration values.

#Aws postgresql how to#

In the following post, we will explore how to get started with Amazon Relational Database Service (RDS) for PostgreSQL. CloudFormation will be used to build a PostgreSQL master database instance and a single read replica in a new VPC.