PolarDB-Tools
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:
-
psql: A client connection tool for PostgreSQL.
For more information, see the psql documentation on the official PostgreSQL website.
-
pg_dump: A logical backup tool for PostgreSQL used to back up a single database in a cluster.
For more information, see the pg_dump documentation on the official PostgreSQL website.
-
pg_restore: A PostgreSQL tool for restoring backup files created by pg_dump and pg_dumpall.
For usage instructions, see the pg_restore documentation on the official PostgreSQL website.
-
ecpg: An embedded SQL C preprocessor.
For more information, see the official ecpg documentation.
-
You can use the community version of the psql tool to execute simple SQL statements when you manage a PolarDB cluster. Note that the community version does not support creating stored procedures. If you attempt to create a stored procedure with this version, the SQL string may be unexpectedly truncated.
-
When you use clients such as psql, pg_dump, and pg_restore, you can download the latest client version. Newer versions are backward-compatible.
Download and installation
-
Download the PolarDB-Tools installation package. The download links are as follows:
PolarDB database engine
System Version
Processor architecture
PolarDB-Tools installation package
PostgreSQL 17
-
AliOS 8
-
Alibaba Cloud Linux 3
Noteglibc version: 2.32.
X86
ARM
-
AliOS 7
-
Alibaba Cloud Linux 2
-
Anolis 7
-
CentOS 7
Noteglibc version: 2.17.
X86
ARM
PostgreSQL 16
-
AliOS 8
-
Alibaba Cloud Linux 3
Noteglibc version: 2.32.
X86
ARM
-
AliOS 7
-
Alibaba Cloud Linux 2
-
Anolis 7
-
CentOS 7
Noteglibc version: 2.17.
X86
ARM
PostgreSQL 15
-
AliOS 8
-
Alibaba Cloud Linux 3
Noteglibc version: 2.32.
X86
ARM
-
AliOS 7
-
Alibaba Cloud Linux 2
-
Anolis 7
-
CentOS 7
Noteglibc version: 2.17.
X86
ARM
PostgreSQL 14
-
AliOS 8
-
Alibaba Cloud Linux 3
Noteglibc version: 2.32.
X86
ARM
-
Anolis 8
-
CentOS 8
-
Rocky 8
Noteglibc version: 2.28.
X86
ARM
-
AliOS 7
-
Alibaba Cloud Linux 2
-
Anolis 7
-
CentOS 7
Noteglibc version: 2.17.
X86
ARM
-
-
Run the following command to install the package.
NoteUse the name of the package that you downloaded.
yum install PolarDB-Tools-2.0.14.30.0-20250301091754.alios7.x86_64.rpmAfter the installation is complete, the tools are located in the
/u01/polardb_pg_tools/bin/directory.