All Products
Search
Document Center

PolarDB:Overview

Last Updated:Jun 21, 2024

This topic describes the components of PolarTools and how to download and install PolarTools.

PolarTools is a set of PolarDB client tools for all versions of Alibaba Cloud Linux, Rocky Linux, CentOS Stream, and CentOS. PolarTools consists of the tools listed in the following table.

Note

We recommend that you use PolarTools to manage PolarDB for PostgreSQL (Compatible with Oracle) clusters.

The tools in PolarTools (such as psql and pg_dump) are different from those in PostgreSQL Community. The tools in PolarTools are adapted to PolarDB for PostgreSQL (Compatible with Oracle). Unknown exceptions may occur or incomplete data may be backed up or restored when you use the tools such as psql and pg_dump in PostgreSQL Community.

Tool

Description

Usage

psql

The client used to connect to PolarDB for PostgreSQL (Compatible with Oracle) clusters.

For more information, see psql at the PostgreSQL official site.

pg_dump

The logical backup tool that backs up a database in a cluster.

For more information, see pg_dump.

pg_dumpall

The logical backup tool that backs up all databases in a cluster.

For more information, see pg_dumpall at the PostgreSQL official site.

pg_restore

The restoration tool that restores the files that you back up by using pg_dump and pg_dumpall.

For more information, see pg_restore at the PostgreSQL official site.

Download and install PolarTools

  1. Download the PolarTools installation package by clicking the following link:

    PolarTools

  2. Run the following command to install PolarTools:

    rpm -ivh PolarDB-O-Tools-0200-2.0.0-.alios7.x86_64.rpm
    Note

    Replace the package name used in the preceding command with the actual name of the installation package.

    After the package is installed, the tools appear in the /usr/local/polardb_o_tools_current/bin directory.