PolarDB-Tools is a set of PostgreSQL client tools packaged for Alibaba Cloud Linux, Rocky Linux, CentOS Stream, and all versions of CentOS. It includes four tools:
| Tool | Description |
|---|---|
| psql | Connects to a PostgreSQL database interactively |
| pg_dump | Creates a logical backup of a single database in a cluster |
| pg_restore | Restores backup files created by pg_dump and pg_dumpall |
| ecpg | Preprocesses embedded SQL in C source files |
For detailed usage, see the official PostgreSQL documentation: psql, pg_dump, pg_restore, and ecpg.
The community version of psql does not support creating stored procedures. If you use it to create a stored procedure, the SQL string may be truncated. Always download the latest client version, which is backward compatible with older database engine versions.
Download and install PolarDB-Tools
Step 1: Download the installation package
Select the package that matches your PolarDB database engine version, operating system, and processor architecture.
PostgreSQL 17
| Operating system | glibc | Architecture | Package |
|---|---|---|---|
| AliOS 8, Alibaba Cloud Linux 3 | 2.32 | x86 | PolarDB-Tools-2.0.17.4.0-20250924100614.al8.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.17.4.0-20250924100614.al8.aarch64.rpm | ||
| AliOS 7, Alibaba Cloud Linux 2, Anolis 7, CentOS 7 | 2.17 | x86 | PolarDB-Tools-2.0.17.4.0-20250924100614.alios7.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.17.4.0-20250924100614.alios7.aarch64.rpm |
PostgreSQL 16
| Operating system | glibc | Architecture | Package |
|---|---|---|---|
| AliOS 8, Alibaba Cloud Linux 3 | 2.32 | x86 | PolarDB-Tools-2.0.16.8.0-20250827095426.al8.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.16.8.0-20250827095426.al8.aarch64.rpm | ||
| AliOS 7, Alibaba Cloud Linux 2, Anolis 7, CentOS 7 | 2.17 | x86 | PolarDB-Tools-2.0.16.8.0-20250827095426.alios7.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.16.8.0-20250827095426.alios7.aarch64.rpm |
PostgreSQL 15
| Operating system | glibc | Architecture | Package |
|---|---|---|---|
| AliOS 8, Alibaba Cloud Linux 3 | 2.32 | x86 | PolarDB-Tools-2.0.15.6.0-20250904171715.al8.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.15.6.0-20250904171715.al8.aarch64.rpm | ||
| AliOS 7, Alibaba Cloud Linux 2, Anolis 7, CentOS 7 | 2.17 | x86 | PolarDB-Tools-2.0.15.6.0-20250904171715.alios7.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.15.6.0-20250904171715.alios7.aarch64.rpm |
PostgreSQL 14
| Operating system | glibc | Architecture | Package |
|---|---|---|---|
| AliOS 8, Alibaba Cloud Linux 3 | 2.32 | x86 | PolarDB-Tools-2.0.14.33.0-20250523102322.al8.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.14.33.0-20250523102322.al8.aarch64.rpm | ||
| Anolis 8, CentOS 8, Rocky 8 | 2.28 | x86 | PolarDB-Tools-2.0.14.31.0-20250516002749.el8.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.14.31.0-20250516002749.el8.aarch64.rpm | ||
| AliOS 7, Alibaba Cloud Linux 2, Anolis 7, CentOS 7 | 2.17 | x86 | PolarDB-Tools-2.0.14.33.0-20250523102322.alios7.x86_64.rpm |
| ARM | PolarDB-Tools-2.0.14.33.0-20250523102322.alios7.aarch64.rpm |
Step 2: Install the package
Run the following command, replacing <package-name> with the filename you downloaded:
yum install <package-name>For example:
yum install PolarDB-Tools-2.0.14.30.0-20250301091754.alios7.x86_64.rpmAfter installation, the tools are available in /u01/polardb_pg_tools/bin/.