Components of PolarDB-Tools and how to download and install PolarDB-Tools - PolarDB

This topic describes the components of PolarDB-Tools and how to download and install PolarDB-Tools.

Usage guide

PolarDB-Tools is a set of PolarDB client tools for Alibaba Cloud Linux, Rocky Linux, CentOS Stream, and all versions of CentOS. It includes the following tools:

Tool name	Description	Usage	Differences from native tools
psql	A client connection tool for PostgreSQL.	The usage is the same as the native psql tool. For more information, see the psql documentation on the official PostgreSQL website.	It is adapted for PolarDB for PostgreSQL (Compatible with Oracle) and supports Oracle compatibility syntax. Using the community version may cause unknown errors. When you manage a PolarDB cluster, you can use the community version of the psql tool if you only need to execute simple SQL statements. Note that the community version of the psql tool does not support creating stored procedures. When you create a stored procedure, the SQL string may be truncated unexpectedly. When you use the psql client, you can download the latest version of PolarDB-Tools, which is compatible with older versions.
pg_dump	A logical backup tool for PostgreSQL used to back up a single database in a cluster.	The usage is the same as the native pg_dump tool. For more information, see the pg_dump documentation on the official PostgreSQL website.	PolarDB supports data backups and redo log backups in the console. For more information, see Backup policy settings. It is adapted for PolarDB for PostgreSQL (Compatible with Oracle) and supports Oracle compatibility syntax. If you use the community version, some objects may not be dumped. When you use the pg_dump client, you can download the latest version of PolarDB-Tools, which is compatible with older versions.
pg_restore	A restoration tool for PostgreSQL used to restore backup files created by pg_dump and pg_dumpall.	The usage is the same as the native pg_restore tool. For more information, see the pg_restore documentation on the official PostgreSQL website.	PolarDB supports two restoration methods: point-in-time restore and restoring from a backup set (snapshot). These methods restore historical data to a new cluster. For more information, see Restoration methods. It is adapted for PolarDB for PostgreSQL (Compatible with Oracle) and supports Oracle compatibility syntax. If you use the community version, some objects may not be restored. When you use the pg_restore client, you can download the latest version of PolarDB-Tools, which is compatible with older versions.
ecpg	An embedded SQL C preprocessor.	The usage is the same as the native ecpg tool. For more information, see the ecpg documentation on the official PostgreSQL website.	It is adapted for PolarDB for PostgreSQL (Compatible with Oracle) and supports Oracle compatibility syntax. If you use the community version, some objects may not be transformed. When you use the ecpg client, you can download the latest version of PolarDB-Tools, which is compatible with older versions.

Download and installation

Download the PolarDB-Tools installation package. The download links are as follows:

System Version	Processor architecture	PolarDB-Tools installation package
AliOS 8 Alibaba Cloud Linux 3 Note glibc version: 2.32.	X86	PolarDB-Tools-2.0.14.47.0-20260730140420.al8.x86_64.rpm
	ARM	PolarDB-Tools-2.0.14.47.0-20260730140420.al8.aarch64.rpm
Anolis 8 CentOS 8 Rocky 8 Note glibc version: 2.28.	X86	PolarDB-Tools-2.0.14.31.0-20250516002749.el8.x86_64.rpm
Anolis 8 CentOS 8 Rocky 8 Note glibc version: 2.28.	ARM	PolarDB-Tools-2.0.14.31.0-20250516002749.el8.aarch64.rpm
AliOS 7 Alibaba Cloud Linux 2 Anolis 7 CentOS 7 Note glibc version: 2.17.	X86	PolarDB-Tools-2.0.14.47.0-20260730140420.alios7.x86_64.rpm
	ARM	PolarDB-Tools-2.0.14.47.0-20260730140420.alios7.aarch64.rpm

Run the following command to install the package.

Note
Use the name of the package that you downloaded.
```
yum install PolarDB-Tools-2.0.14.30.0-20250301091754.alios7.x86_64.rpm
```
After the installation is complete, the tools are located in the /u01/polardb_pg_tools/bin/ directory.