How to Run PostgreSQL on ApsaraDB for RDS

By Kelvin Galabuzi

What Is ApsaraDB for RDS?

Alibaba Cloud ApsaraDB for RDS is a fast, stable, reliable, and scalable database service. ApsaraDB for RDS supports different SQL Server engines, including MySQL, SQL Server, PostgreSQL, and MariaDB.

Key Features of ApsaraDB RDS for PostgreSQL

ApsaraDB RDS for PostgreSQL supports a flexible spatial information process, enabling precise positioning of earthly data using PostGIS extensions that meet the OpenGIS standard. This also comes with various spatial data types and functions that boost development with Geographical Information Systems (GIS).
Integration with NoSQL: ApsaraDB RDS for PostgreSQL uses SQL statements compatible with unstructured data types, such as JSON, XML, and Key value.
ApsaraDB RDS for PostgreSQL supports performing full-text searches without creating additional search engines.
Object Storage Service Expansion: Apsara DB RDS for Postgres integrates managing external tables stored in Alibaba Object Storage Service and supports unlimited storage expansion.
ApsaraDB RDS for PostgreSQL also meets the needs of resource-intensive Online Transaction Processing (OLTP) applications and Online Analytical processing applications. This ensures that organizations can build data warehouses for real-time data analysis.

Create and Access an ApsaraDB RDS for PostgreSQL Server Instance

The following section will cover creating and accessing an ApsaraDB for RDS PostgreSQL Server Instance.

Step 1: On the Alibaba Cloud console, access the ApsaraDB for RDS service under the Relational Databases service category:

Step 2: On the ApsaraDB RDS console, click Create Instance, which will lead you to the configuration page of a new RDS Instance:

Step 3: Select your billing method, the Database engine, which is the PostgreSQL, and the storage type:

Step 4: Select the zone of the primary node, the deployment method, instance type, capacity, and then click next on the Instance configuration:

Note: We recommended running production-grade workloads in a multi-zone deployment to ensure high availability.

Step 5: Select the VPC, VSwitch, resource group, and click Next to confirm your order:

Step 6: Review all the configurations you have set up for your instance and click Pay Now:

Step 7: On the ApsaraDB for RDS instances console, you should see that the instance is running under the Instances blade. Select your running instance to start managing it:

Step 8: On your instance, select the Accounts section and then click Create Account:

Step 9: Selecting the create account option will open a slide on the left side of the screen. Fill in the required details to create the privileged account and click OK:

Step 10: Access the Database connection blade to configure the database access settings. Click Apply for Public Endpoint to allow you to access your database from the Internet. You can leave it to the Internal endpoint if you prefer the database only to be accessed from within your VPC:

Step 11: Click Configure Whitelist on your new public endpoint to allow external access from your preferred IP locations and click OK:

Note: We advise against allowing access to your Database instance from all locations. Only do this for test purposes with databases with no sensitive data.

Step 12: Click Log On to Database to access your database instance using the Alibaba Cloud Data Management service:

Step 13: A new screen with the Data Management service will pop up. Insert all the details required to connect to your ApsaraDB RDS for PostgreSQL Server instance and then click Login:

Step 14: After successfully connecting, you can start managing your PostgreSQL Server instance:

Community

How to Run PostgreSQL on ApsaraDB for RDS

What Is ApsaraDB for RDS?

Key Features of ApsaraDB RDS for PostgreSQL

Create and Access an ApsaraDB RDS for PostgreSQL Server Instance

Read previous post:

Read next post:

Alibaba Cloud Community

You may also like

Comments

Alibaba Cloud Community

Related Products

PolarDB for PostgreSQL

PolarDB for MySQL

Database for FinTech Solution

ApsaraDB for MyBase