Backup and restore of PostgreSQL database (Pg_dump and Pg_restore)

Source: Internet
Author: User
Tags postgresql unpack phpmyadmin

Pg_dump used to back up the database;

Pg_restore used to restore the database;

The backed-up files can be compressed with XZ (Linux's own compression tool).

XZ compression The latest compression rate of the King

XZ This compression may be a lot of strange, but you can know that XZ is the largest number of Linux by default with a compression tool.

Before XZ use has been very little, so there is hardly anything to mention.

I was in the download phpmyadmin when I saw this compression format, phpMyAdmin compression package XZ format is actually smaller than 7z, which aroused my interest.

The latest period of time will often hear the voice of XZ being used, like the newest archlinux something that uses XZ compression. But XZ also has a disadvantage is the compression time is longer, than 7z compression time is longer. However, compression is disposable, so it can be ignored.

XZ compressed file method or command

xz-z files to compress

If you want to keep the compressed file plus the parameter-K, if you want to set the compression rate add parameter-0 to-9 to adjust the compression rate. If not set, the default compression level is 6.

XZ decompression File method or command

xz-d files to Unzip

Also use the-K parameter to preserve the extracted files.

How to create or unzip a tar.xz file

People accustomed to tar czvf or tar xzvf may encounter tar.xz and would like to use a single command to extract or compress. In fact, there's no tar. Parameters for XZ format such as Z are for gzip,j are for bzip2.

Create a TAR.XZ file: Just first tar cvf xxx.tar xxx/Create the Xxx.tar file first, then use Xz-z Xxx.tar to compress Xxx.tar into XXX.TAR.XZ

Unzip Tar.xz file: First xz-d XXX.TAR.XZ will xxx.tar.xz decompression into Xxx.tar then, then use tar xvf xxx.tar to unpack.

XZ compression The latest compression rate of the King

XZ This compression may be a lot of strange, but you can know that XZ is the largest number of Linux by default with a compression tool.

Before XZ use has been very little, so there is hardly anything to mention.

I was in the download phpmyadmin when I saw this compression format, phpMyAdmin compression package XZ format is actually smaller than 7z, which aroused my interest.

The latest period of time will often hear the voice of XZ being used, like the newest archlinux something that uses XZ compression. But XZ also has a disadvantage is the compression time is longer, than 7z compression time is longer. However, compression is disposable, so it can be ignored.

XZ compressed file method or command

xz-z files to compress

If you want to keep the compressed file plus the parameter-K, if you want to set the compression rate add parameter-0 to-9 to adjust the compression rate. If not set, the default compression level is 6.

XZ decompression File method or command

xz-d files to Unzip

Also use the-K parameter to preserve the extracted files.

How to create or unzip a tar.xz file

People accustomed to tar czvf or tar xzvf may encounter tar.xz and would like to use a single command to extract or compress. In fact, there's no tar. Parameters for XZ format such as Z are for gzip,j are for bzip2.

Create a TAR.XZ file: Just first tar cvf xxx.tar xxx/Create the Xxx.tar file first, then use Xz-z Xxx.tar to compress Xxx.tar into XXX.TAR.XZ

Unzip Tar.xz file: First xz-d XXX.TAR.XZ will xxx.tar.xz decompression into Xxx.tar then, then use tar xvf xxx.tar to unpack.

Backup and restore of PostgreSQL database (Pg_dump and Pg_restore)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.