Community Blog New Features of PostgreSQL 13 and Migration Tutorial

New Features of PostgreSQL 13 and Migration Tutorial

This article introduces the new features and changes of PostgreSQL 13 and how to migrate from a relational PostgreSQL to ApsaraDB RDS for PostgreSQL.

First Experience with PostgreSQL 13 Beta 1

On May 21, 2020, the PostgreSQL Global Development Group announced that the first beta release of PostgreSQL 13 was available for download. This release contains previews of all features that will be available in the final release of PostgreSQL 13, though some details of the release could change before then. Let's look at the new features and changes found in PostgreSQL 13.

New Features in PostgreSQL 13

In the community's published document, we can see that the new features of PostgreSQL 13 are divided into the following sections:

  1. Functionality
  2. Administration
  3. Security

Other highlights:

  1. PostgreSQL 13 continues to improve operability on Windows. Users that run PostgreSQL on Windows now have the option to connect over UNIX domain sockets.
  2. The PostgreSQL 13 documentation adds a glossary of terms to help people familiarize themselves with both PostgreSQL and general database concepts. This coincides with a significant rework in the display of functions and operators in tables, which helps to improve readability both on the web and in the PDF documentation.
  3. The pgbench utility, used for performance testing, now supports the ability to partition its "accounts" table, making it easier to benchmark workloads that contain partitions.
  4. The psql tool now includes the warn command that is similar to the echo command in terms of outputting data, except warn sends it to stderr. In case you need additional guidance on the PostgreSQL commands, the --help flag now includes a link to https://www.postgresql.org.

In this blog, Zhuodao takes a look at all the new features and changes.

Migrating from a Relational PostgreSQL to ApsaraDB RDS for PostgreSQL

In this tutorial we have shown how to migrate from your relational PostgreSQL database to the ApsaraDB for Relational PostgreSQL database on the ApsaraDB for RDS Server.

About ApsaraDB

Traditionally, databases have resided within instances of a database server such as SQL Server, MySQL, MongoDB and others.

Sometimes the database engine runs on the same server as the application whose data it stores. For example, a single Linux server might run Apache, PHP and MySQL.

As the application scales and more performance is required, moving the database to its own server is the obvious next step. Just set up a new Linux or Windows server, install the requisite database engine and migrate the data. Then it's just a case of changing some configuration files within the application code to point the application at the new database server.

As part of the world moved towards cloud computing infrastructure, new database server architecture arrived. Cloud providers such as Alibaba Cloud now offer database server instances as a service. No longer is there any need to run a dedicated Windows or Linux server purely to host a copy of MySQL or SQL Server. No longer do you need to patch your database server or manage its security.

Alibaba Cloud's database service is called ApsaraDB and it's currently available for SQL Server, MySQL, PostgreSQL, and Postgres Plus Advanced Server (PPAS), which is compatible with Oracle.

ApsaraDB instances are fast, cost-effective, easy to back up and very quick to scale when you need additional performance. They all run on SSD drives and you simply pay according to the amount of data you process. If you need more performance or storage, it can be arranged with just a few clicks on the management console. Pricing is based on a monthly subscription that starts from USD $29. Or if you prefer, a pay-as-you-go option starts from less than 3 cents ($0.29) per hour provided that your ApsaraDB instance is active (storage and Internet traffic are additional costs).

Just as with a cloud-based Linux or Windows server instance, ApsaraDB database instances include a comprehensive monitoring system that's built-in. You can keep a close eye on the performance of your hosted databases, in order to help you make decisions about whether additional resources might be required. You can set alarms and triggers so that you will automatically be notified if performance or disk space falls below specified thresholds.

With an ApsaraDB instance, there's no underlying operating system or virtual server for you to pay for, secure, patch or manage. You get to concentrate on managing just your database tables. Everything else is taken care of by Alibaba Cloud.

ApsaraDB includes security features such as real-time monitoring of network traffic, and automatic interception of SQL injection, brute force attacks and other types of database attacks. This is all built into each ApsaraDB instance and does not need to be configured or purchased separately, as would be the case if you hosted your databases on a conventional cloud server running Linux or Windows and a separate relational database management system (RDBMS).

This tutorial will show you how to migrate from a relational PostgreSQL to ApsaraDB for relational PostgreSQL Database.

Further information, as well as documentation about how to use other database technologies apart from PostgreSQL, can be found in the Database Services section of the Products menu on the Alibaba Cloud website.

Related Products

ApsaraDB for PolarDB

ApsaraDB for PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. ApsaraDB for PolarDB provides the performance and availability of traditional enterprise databases and the flexibility and cost-effectiveness of open-source databases.

ApsaraDB for PolarDB is designed for business-critical database applications that require fast performance, high concurrency, and automatic scaling. You can scale up to millions of queries per second and 100 TB per database cluster with 15 low latency read replicas. ApsaraDB for PolarDB is six times faster than standard MySQL databases, and delivers the security, reliability, and availability of traditional commercial databases at 1/10 the cost. ApsaraDB for PolarDB embodies the proven database technology and best practices honed over the last decade that supported hyper-scale events such as the Alibaba Double 11 Global Shopping Festival.

Related Documentation

Architecture of ApsaraDB for PolarDB

PolarDB is based on the cloud native architecture. PolarDB provides the benefits of commercial databases and open source cloud databases. Commercial databases offer the benefits of stability, reliability, high performance, and scalability. Open source cloud databases offer the benefits of simplicity, openness, and rapid iteration. This topic describes the architecture and features of PolarDB.

0 0 0
Share on

Alibaba Clouder

2,605 posts | 747 followers

You may also like