Common management tasks for Amazon RDS for PostgreSQL
The following are the common management tasks you perform with an Amazon RDS for PostgreSQL DB instance, with links to relevant documentation for each task.
| Task area | Relevant documentation |
|---|---|
|
Setting up Amazon RDS for first-time use Before you can create your DB instance, make sure to complete a few prerequisites. For example, DB instances are created by default with a firewall that prevents access to it. So you need to create a security group with the correct IP addresses and network configuration to access the DB instance. |
|
|
Understanding Amazon RDS DB instances If you are creating a DB instance for production purposes, you should understand how instance classes, storage types, and Provisioned IOPS work in Amazon RDS. |
|
|
Finding available PostgreSQL versions Amazon RDS supports several versions of PostgreSQL. |
|
|
Setting up high availability and failover support A production DB instance should use Multi-AZ deployments. Multi-AZ deployments provide increased availability, data durability, and fault tolerance for DB instances. |
Configuring and managing a Multi-AZ deployment for Amazon RDS |
|
Understanding the Amazon Virtual Private Cloud (VPC) network If your AWS account has a default VPC, then your DB instance is automatically created inside the default VPC. In some cases, your account might not have a default VPC, and you might want the DB instance in a VPC. In these cases, create the VPC and subnet groups before you create the DB instance. |
|
|
Importing data into Amazon RDS PostgreSQL You can use several different tools to import data into your PostgreSQL DB instance on Amazon RDS. |
|
|
Setting up read-only read replicas (primary and standbys) RDS for PostgreSQL supports read replicas in both the same AWS Region and in a different AWS Region from the primary instance. |
Working with DB instance read replicas |
|
Understanding security groups By default, DB instances are created with a firewall that prevents access to them. To provide access through that firewall, you edit the inbound rules for the VPC security group associated with the VPC hosting the DB instance. |
|
|
Setting up parameter groups and features To change the default parameters for your DB instance, create a custom DB parameter group and change settings to that. If you do this before creating your DB instance, you can choose your custom DB parameter group when you create the instance. |
|
|
Connecting to your PostgreSQL DB instance After creating a security group and associating it to a DB
instance, you can connect to the DB instance using any standard SQL
client application such as |
Connecting to a DB instance running the PostgreSQL database engine |
|
Backing up and restoring your DB instance You can configure your DB instance to take automated backups, or take manual snapshots, and then restore instances from the backups or snapshots. |
|
|
Monitoring the activity and performance of your DB instance You can monitor a PostgreSQL DB instance by using CloudWatch Amazon RDS metrics, events, and enhanced monitoring. |
|
|
Upgrading the PostgreSQL database version You can do both major and minor version upgrades for your PostgreSQL DB instance. |
|
|
Working with log files You can access the log files for your PostgreSQL DB instance. |
|
|
Understanding the best practices for PostgreSQL DB instances Find some of the best practices for working with PostgreSQL on Amazon RDS. |
Following is a list of other sections in this guide that can help you understand and use important features of RDS for PostgreSQL: