• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Getting Started with PostgreSQL
  5. Restrictions

Restrictions

Table 1 shows the restrictions designed to ensure the stability and security of RDS for PostgreSQL.

Table 1 Function restrictions

Function Item

Restrictions

Access RDS

  • If the public accessibility function is not enabled, RDS DB instances must be in the same VPC subnet as the ECS.
  • RDS read replicas must be created in the same subnet as the primary DB instance.
  • The ECS must be allowed by the security group to access RDS DB instances.

    By default, RDS cannot be accessed through an ECS in a different security group. You need to add an inbound rule to the RDS security group.

  • The default RDS port is 5432. You can change it if you want to access RDS through another port.

Deployment

ECSs in which DB instances are deployed are not visible to you. You can access the DB instances only through an IP address and a port number.

Database root permissions

Only the root user permissions are provided on the instance creation page.

Modify database parameters

Most parameters can be modified on the RDS console.

Import data

You can use the psql command line tool to migrate data.

For details, see Migrating PostgreSQL Data Using psql.

Set up database replication

RDS for PostgreSQL provides a dual-node cluster with primary/standby replication architecture. You do not need to set up replication. The standby DB instance is not visible and therefore you cannot access it directly.

Reboot an RDS DB instance

DB instances cannot be rebooted through commands. They must be rebooted on the RDS console.

View RDS backups

RDS backup files are stored in OBS buckets and are not visible to you.