Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to use pg_rman, a physical backup tool for PostgreSQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

OS: Ubuntu 16.04.4 LTS

Database: postgresql-10.5

Pg_rman is an excellent online backup and recovery tool for postgresql.

Download: https://github.com/ossc-db/pg_rman

Working with documents: http://ossc-db.github.io/pg_rman/index.html

Reference: https://github.com/ossc-db/pg_rman/tree/master

Each version of the package: https://github.com/ossc-db/pg_rman/releases

Because the database version is postgresql-10.5, you need to download the corresponding pg_rman REL_10_STABLE: branch for postgresql-10.5

# su-postgres$ mkdir packages$ cd packages/$ git clone https://github.com/ossc-db/pg_rman.git$ cd pg_rman/$ git branch-a view branches of all versions

$git checkout REL_10_STABLE specifies the branch corresponding to the postgresql version

$git status View status

Make install starts to install the pg_rman output:

If an error occurs in make install:

Solution: $vim MakefilePG_CONFIG=/services/database/install/postgresql/bin/pg_config description: specify the path to your postgresql executable. Execute again: $make install to complete the installation.

The pg_rman backup tool has been installed.

Thank you for reading! This is the end of this article on "how to use pg_rman, a physical backup tool for PostgreSQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.