Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 GMT+08:00

Connecting to an RDS for PostgreSQL Instance

You can connect to an RDS for PostgreSQL instance through the command-line interface (CLI), graphical user interface (GUI), Data Admin Service (DAS), and Java database connectivity (JDBC).

Table 1 Connection methods

Connection Method

Description

Connecting to an RDS for PostgreSQL Instance Through DAS (Recommended)

DAS enables you to manage databases on a web-based console and supports SQL execution, advanced database management, and intelligent O&M, simplifying database management and improving working efficiency and data security. The permissions required for connecting DB instances through DAS are enabled by default.

Connecting to an RDS for PostgreSQL Instance Through the psql CLI Client

In a Linux OS, you need to install a PostgreSQL client on the ECS and connect to the instance through the psql CLI over a private or public network.

  • A private IP address is provided by default.

    When your applications are deployed on an ECS that is in the same region and VPC as the RDS for PostgreSQL instance, you are advised to use a floating IP address to connect to the instance through the ECS.

  • If you cannot access your RDS for PostgreSQL instance through a floating IP address, bind an EIP to the instance and connect to the instance through the EIP.

Connecting to an RDS for PostgreSQL Instance Through the GUI

In a Windows OS, you can use the pgAdmin client to connect to an RDS for PostgreSQL instance.

Connecting to an RDS for PostgreSQL Instance Through JDBC

If you are connecting to an instance through JDBC, the SSL certificate is optional. For security reasons, you are advised to download the SSL certificate to encrypt the connection.

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel