This topic describes the components of PolarDB-Tools and describes how to download and install PolarDB-Tools.
Usage
PolarDB-Tools is a set of PolarDB client tools for all versions of Alibaba Cloud Linux, Rocky Linux, CentOS Stream, and CentOS. PolarTools consists of the following tools:
psql: a command-line client for interacting with PostgreSQL databases.
For more information, see the psql topic on the PostgreSQL official website.
pg_dump: a logical backup tool of PostgreSQL. You can use this tool to back up a database in a cluster.
For more information, see the pg_dump topic on the PostgreSQL official website.
pg_restore: a tool used to restore PostgreSQL databases from backup files that are created by pg_dump and pg_dumpall.
For more information, see the pg_restore topic on the PostgreSQL official website.
ecpg: the embedded SQL preprocessor for C programs.
For more information, see the ecpg topic on the PostgreSQL official website.
pg_repack: a client tool used to reclaim tablespaces.
For more information, see pg_repack.
For pg_repack, you must use the PolarDB version. For other tools such as psql, pg_dump, and pg_restore, you can use the community version.
If you need to execute only simple SQL statements for managing PolarDB clusters, you can use the community version psql. Note that the community version psql does not support creating stored procedures. If you attempt to create a stored procedure, the SQL statements are incorrectly truncated during the creation process.
For tools such as psql, pg_dump, and pg_restore, you can download the last versions for compatibility purpose.
For pg_repack, the client version must match the server version. Download the PolarDB-Tools installation package that matches the version of your PolarDB cluster.
Download and installation
Download the PolarDB-Tools installation package by clicking one of the following links:
PolarDB database engine
Operating system version
Processor architecture
PolarDB revision version
pg_repack version
PolarDB-Tools version
PolarDB-Tools installation package
PostgreSQL 15
AliOS 8/
ALinux 3/
Anolis 8/
CentOS 8
X86
15.7.2.0
1.5.1-1
20240815
ARM
15.7.2.0
1.5.1-1
20240815
AliOS 7/
ALinux 2/
Anolis 7/
CentOS 7
X86
15.7.2.0
1.5.1-1
20240815
ARM
15.7.2.0
1.5.1-1
20240815
PostgreSQL 14
AliOS 8/
ALinux 3/
Anolis 8/
CentOS 8
X86
14.13.25.0
1.5.1-1
20240930
14.12.24.0
1.5.1-1
20240830
ARM
14.13.25.0
1.5.1-1
20240930
14.12.24.0
1.5.1-1
20240830
AliOS 7/
ALinux 2/
Anolis 7/
CentOS 7
X86
14.13.25.0
1.5.1-1
20240930
14.12.24.0
1.5.1-1
20240830
ARM
14.13.25.0
1.5.1-1
20240930
14.12.24.0
1.5.1-1
20240830
Run the following installation command:
yum install PolarDB-Tools-2.0.14.10.0-20230622222102.al8.x86_64.rpmNoteUse the name of the installation package that you download to replace the sample name used in the preceding command.
After the tool is installed, the tool appears in the
/u01/polardb_pg_tools/bin/directory of the system.