Backup and restore of PostgreSQL database (Pg_dump and Pg_restore)

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)