ApsaraDB RDS for PostgreSQL  Play Video

An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilities

Latest News

Product News

RDS for PostgreSQL 16 Has Arrived
Enhanced security, efficiency, and more
Learn More >

Upgrade RDS for PostgreSQL Major Version In One Click
You are allowed to upgrade from any version(since PG 10) to the latest with one click only if the disk type of your instance is cloud disk. Upgrade metrix:
PG 10 -> PG 11~16

Learn More >

Most Popular

Video: How to upgrade RDS PostgreSQL major version in just one click
Watch the video in 7 minutes and upgrade PostgreSQL seamlessly with no impact on your business.

More Video >

Must-Read Blogs

Hands-On Lab | Migrate User-Created PostgreSQL to ApsaraDB RDS for PostgreSQL through Cloud Migration
Learn More >

Best Practice | How to Build a Heat Map Tile App with Alibaba Cloud ECS & PostgreSQL/Ganos: A Step-by-Step Guide
Learn More >

How To | Build GIS Heat Map APP With Ganos on ApsaraDB RDS for PostgreSQL

Known as "the world’s most advanced open source relational database", PostgreSQL enables OLTP databases that handle enterprise-level SQL statements, supports NoSQL data types such as JSON, XML and hstore, and supports GIS data processing.

Popular Scenarios

Discover what and how you can use our products to build >

BI

PostgreSQL BI Dashboard Toolkit

Streamline BI dashboard creation using Cube, React, and ApsaraDB RDS for PostgreSQL. Learn more >

  • Plug-and-Play
  • Simplified Management
  • Smooth Integration

Product Used

ECS | ApsaraDB RDS for PostgreSQL

Begin Your Journey

GIS

PostgreSQL GIS Heat Map Power Visual

Develop dynamic heat maps with geo-visualization and analytics on ApsaraDB RDS for PostgreSQL featuring Ganos. Learn more >

  • All-Inclusive Features
  • Superior Performance
  • Fortified Security

Product Used

ECS | ApsaraDB RDS for PostgreSQL

Begin Your Journey

Free Trials & Special Offers

See Special Offer Terms & Conditions for specifics and limitations.

ApsaraDB RDS for PostgreSQL Serverless

Scale automatically in seconds, only pay for actual usage, lower cost

50% OFF

PostgreSQL 14/15/16

Basic/High-Availability Edition

All Available Regions

All Users
From $0.03 /Hour

ApsaraDB RDS for PostgreSQL

OLTP scenarios, GIS and other NoSQL data support.

Free

PostgreSQL 11~16 High-availability

pg.n2.2c.2m

2C4G, 20 GB ESSD PL1

New User Only
30 Days Free

ApsaraDB RDS for PostgreSQL

OLTP scenarios, GIS and other NoSQL data support.

Free

PostgreSQL 11~16 Basic

pg.n2.2c.1m

2C4G, 20 GB ESSD PL1

New User Only
30 Days Free

Benefits

NoSQL compatibility
Compatible with SQL:2011 and supports multiple data types, such as JSON and XML.
Multiple Extensions
Supports GIS data, cloud storage expansion, and Chinese text segmentation to make development easier.
Efficient Querying
Provides a cost-based SQL query optimizer that shows significantly better performance in multi-table queries than MySQL.
Secure and Stable
Supports SQL auditing and field permission control. Provides IP whitelists to prevent DDoS attacks.

Features

  • Easy Spatial Information Processing

    With PostGIS extensions, the service supports 2D and 3D geographical data modelling, and recognizes the shifts caused by the irregular shape of the Earth to enable precise positioning that meets the OpenGIS standard.


    Spatial data types

    Supports spatial data types such as POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, and GEOMETRYCOLLECTION.


    Spatial functions

    Supports spatial functions such as Area, Length, and Distance.


    Metadata types and functions

    Supports GEOMETRY_COLUMNS and SPATIAL_REF_SYS.


    Binary predicates

    Supports binary predicates such as Contains, Within, Overlaps, and Touches.


    Spatial operators

    Supports spatial operators such as Union and Difference.

  • Strong Compatibility with NoSQL

    The SQL statements support unstructured data types such as JSON, XML, and Key-Value, which enables a Not Only SQL (NoSQL) solution.


    Create tables using JSON data

    For example, CREATE TABLE json_tab(id bigint, data jsonb);


    Directly save JSON data

    For example, INSERT INTO json_tab VALUES (1,'{""pname"":""Product 1"",""qty"":50}')


    Directly query JSON data

    For example, SELECT * FROM json_tab WHERE data->>'qty' > 30


    Index JSON attributes to enhance performance

    For example, CREATE INDEX idx_json_tab_data_pname ON json_tab USING btree ((data ->> 'pname'));


    Perform JOIN queries on existing tables

    For example, SELECT * FROM json_tab JOIN product ON (products.pname=json_data.data->>'pname') WHERE data->>'qty' > 30;

  • Supports Full-text Search

    You can use SQL operations to perform full-text searches and fuzzy queries without the need to create additional search engines.


    Multiple features

    Supports Chinese text segmentation and custom word banks, and allows you to continuously process and optimize existing word banks. The service also offers advanced features such as jieba segmenter, similarity analysis, similarity indexing, and regular expression matching. You can use the SQL engine to perform text segmentation smoothly and easily.

  • Supports OSS Storage Expansion

    Based on the Foreign Data Wrapper (FDW) feature of PostgreSQL, ApsaraDB RDS for PostgreSQL integrates the management of external tables stored in OSS and supports flexible storage expansion.


    Readable, writeable, and flexible storage

    With external tables, you can use the CSV files stored in OSS as local data tables. The service also allows you to perform JOIN queries involving local tables, to read and write data directly, and to flexibly increase the database size to meet your needs for the management of hot and cold data lifecycles. You can also use the standard GZIP algorithm to compress the CSV files stored as external tables in OSS. This effectively shortens the data writing time to OSS and lowers the storage cost by more than 50%.

  • Supports Data Warehousing

    ApsaraDB RDS for PostgreSQL meets the high availability needs of OLTP applications, and also supports OLAP data warehouses for real-time data analysis.


    OLAP + OLTP = HTAP

    Provides the same database driver for online databases and data warehouses, which helps SMEs reduce the development cost. To analyze TB size data, you can use AnalyticDB RDS for PostgreSQL to create OLAP data warehouses that support horizontal scaling, and BI transactions that involve analyzing hundreds of TB or PB size data.

How it works

  • Standard enterprise-level PostgreSQL solution
  • Flexible storage expansion
  • Boosts IoT development with GIS and JSON
Standard enterprise-level PostgreSQL solution

Standard enterprise-level PostgreSQL solution

Core business database

Based on Alibaba Cloud multi-zone architecture, the service supports local disaster recovery and ensures the security and stability of enterprise databases. Compared with other open source databases, PostgreSQL is a better choice for online transaction processing, and shows better performance at JOIN queries involving multiple tables.

Benefits

  • Supports large tables

    Each table can contain hundreds of millions of rows. Maintains high performance in multi-table queries based on Hash JOIN.

  • OLAP solutions

    Provides OLAP support for tables of hundreds of gigabytes. For larger sizes of data, AnalyticDB for PostgreSQL supports horizontal scaling.

  • Flexible storage

    Allows you to store cold data in external tables in OSS. Supports interaction with AnalyticDB for PostgreSQL.

Related Products and Services

Flexible storage expansion

Flexible storage expansion

Breaks the limit of RDS storage

To expand your storage, you can store frequently used hot data in SSDs and use OSS to store cold data. You can also compress OSS data based on the standard GZIP algorithm to further reduce the storage cost. With AnalyticDB for PostgreSQL, you can expand your OLAP applications horizontally to provide better performance and more storage space.

Benefits

  • Log storage

    Provides flexible storage based on OSS.

  • Analysis of large amounts of BI data

    Use AnalyticDB for PostgreSQL to implement high performance analysis using the same SQL grammar.

Related Products and Services

Boosts IoT development with GIS and JSON

Boosts IoT development with GIS and JSON

Increase the productivity of developers and database administrators with SQL

JSON and GIS data types are essential for processing IoT transactions. In traditional solutions, developers and database administrators frequently use hardcoding when interacting with NoSQL databases and professional GIS analytical tools. With PostgreSQL, you can use SQL to perform operations on JSON and GIS data directly. This saves the trouble of data imports and significantly increases the development efficiency.

Benefits

  • Sensor data of JSON format

    Use SQL to perform relational queries and lower the development cost.

  • GIS data

    Precise positioning. Supports 2D and 3D data types, route planning, and raster data analysis.

Related Products and Services

Rely on Alibaba Cloud's Worldwide Data Centers

Alibaba Cloud has 87 zones strategically located across 29 regions in the world, providing reliable computing support for billions of customers.

  • No.1

    Market Share in the Asia Pacific

    IaaS Market Share - Gartner IT Service Report 2022

  • 29

    Global Data Center regions
  • 3,200 +

    CDN Nodes Globally
  • 87

    Availability Zones

2

US East

2

US West

2

UK

3

Germany

3

Middle East

1

Thailand

2

Malaysia

3

Japan

1

South Korea

2

Australia(Closing Down)

3

China (Hong Kong)

22

China North

10

China South

2

China West

21

China East

3

Singapore

3

Indonesia

1

Philippines

1

Central China

Data centers and availability zones

Upgraded Support For You

1 on 1 Presale Consultation, 24/7 Technical Support, Faster Response, and More Free Tickets.

1 on 1 Presale Consultation

Consulting by experienced cloud experts.Learn More

24/7 Technical Support

Extended service time from 10 hours 5 days a week to 24/7. Learn More

6 Free Tickets per Quarter

The number of free tickets doubled from 3 to 6 per quarter. Learn More

Faster Response

Shorten after-sale response time from 36 hours to 18 hours. Learn More
phone Contact Us