Help Center/Relational Database Service/Getting Started/Getting Started with RDS for PostgreSQL/RDS for PostgreSQL Common Tasks

Updated on 2025-11-11 GMT+08:00

RDS for PostgreSQL Common Tasks

After purchasing and connecting to a DB instance, you can view common tasks to better use RDS for PostgreSQL.

**Table 1** Common tasks
Tasks		Description
Usage guidelines	Instance Guidelines	Provides guidelines on using RDS for PostgreSQL in terms of database connection, read replicas, reliability and availability, logical replication, database age, stability, routine O&M, and security.
Usage guidelines	Database Guidelines	Provides guidelines on database naming, table design, index design, SQL design, and security.
Data migration	Migrating Data to RDS for PostgreSQL Using psql	Describes how to use pg_dump to copy data from the source to an RDS for PostgreSQL DB instance.
	From RDS for PostgreSQL to RDS for PostgreSQL	Describes how to use DRS to synchronize data from the source to an RDS for PostgreSQL DB instance.
	From Self-Managed PostgreSQL to RDS for PostgreSQL	Describes how to use DRS to synchronize data from a self-managed PostgreSQL database to an RDS for PostgreSQL DB instance.
	From PostgreSQL on Other Clouds to RDS for PostgreSQL	Describes how to use DRS to synchronize data from PostgreSQL databases on other clouds to RDS for PostgreSQL.
	From Oracle to RDS for PostgreSQL	Describes how to use DRS to synchronize data from a self-managed Oracle database to an RDS for PostgreSQL DB instance.
	From RDS for MySQL to RDS for PostgreSQL	Describes how to use DRS to synchronize data from an RDS for MySQL DB instance to an RDS for PostgreSQL DB instance.
	From Self-Managed MySQL to RDS for PostgreSQL	Describes how to use DRS to synchronize data from a self-managed MySQL database to an RDS for PostgreSQL DB instance.
	From MySQL on Other Clouds to RDS for PostgreSQL	Describes how to use DRS to synchronize data from MySQL databases on other clouds to RDS for PostgreSQL.
Data backup	Same-Region Automated Backup	Describes how RDS for PostgreSQL automatically creates backups for a DB instance during a backup window and saves the backups based on the configured retention period.
Data backup	Same-Region Manual Backup	Describes how to create manual backups for a DB instance. These backups can be used to restore data for improved reliability.
Data restoration	Restoring from Full Backups to RDS for PostgreSQL Instances	Describes how to use an automated or manual backup to restore a DB instance to how it was when the backup was created. The restoration is at the instance level.
Data restoration	Restoring a DB Instance to a Point in Time	Describes how to use an automated backup to restore instance data to a specified point in time.

Parent Topic: Getting Started with RDS for PostgreSQL

Previous topic: Buying an RDS for PostgreSQL Instance and Connecting to It Using a PostgreSQL Client

Next topic: Getting Started with RDS for SQL Server

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.