In today’s article, I will tell you about Pgbackrest Installation on PostgreSQL Community 13.<\/p>\n
If you have not installed PostgreSQL Community before, you can install it by following the link below.<\/p>\n
https:\/\/dbtut.com\/index.php\/2022\/03\/13\/postgresql-community-13-installation-on-oracle-linux-7\/<\/pre>\nBriefly, pgBackrest is a backup tool for PostgreSQL. You can get full backup, incremental backup, differantial backup with this tool. You can restore from these backups or simply restore the missing files.<\/p>\n
After briefly explaining what pgBackrest is, we can start the installation. First, we install pgBacgrest.<\/p>\n
[root@testdb ~]#yum -y install pgbackrest<\/pre>\nRepository Creation:<\/h5>\n
The repository is where pgBackRest stores backups and archives WAL segments.<\/p>\n
[root@testdb ~]#mkdir -p \/pg_backup\/pgbackrest\r\n[root@testdb ~]#chmod 750 \/pg_backup\/pgbackrest\r\n[root@testdb ~]#chown postgres:postgres \/pg_backup\/pgbackrest<\/pre>\nArchiving Configuration:<\/h5>\n
To put the database in archive mode, we write the following parameters into the postgresql.conf file.<\/p>\n
archive_mode = on\r\narchive_command = \u2018pgbackrest --stanza=demo archive-push %p\u2019<\/pre>\nWe restart the postgresql service so that the change we made can be active.<\/p>\n
[root@testdb ~]#systemctl restart postgresql-13<\/pre>\nBackup<\/h5>\n
If we are going to backup on the same server, we configure pgBackrest as follows.<\/p>\n
$ vi \/etc\/pgbackrest.conf\r\n[global]\r\nrepo-path=\/pg_backup\/pgbackrest\/\r\nbackup-user=postgres\r\nretention-full=2\r\nretention-diff=2\r\nprocess-max=3\r\nlog-path=\/pg_backup\/log\/pgbackrest\r\n[demo]\r\npg1-path=\/var\/lib\/pgsql\/13\/data\/<\/pre>\nIf a backup will be made to a different server, we will configure both the master server and the server that we will backup.<\/p>\n
The pgBacrest configuration to be done on the master server:<\/p>\n
$vi \/etc\/pgbackrest.conf\r\n[global]\r\nrepo1-host=<backup-sunucu-ip>\r\nrepo1-host-user=postgres\r\n[demo]\r\npg1-path=\/var\/lib\/pgsql\/13\/data\/<\/pre>\nThe pgBackrest configuration to be made on the server to be backed up:<\/p>\n
$ vi \/etc\/pgbackrest.conf\r\n[global]\r\nrepo1-path=\/pg_backup\/pgbackrest\r\nrepo1-retention-full=2\r\nrepo1-retention-diff=2\r\nprocess-max=3\r\n[demo]\r\npg1-host=<master-sunucu-ip>\r\npg1-path=\/var\/lib\/pgsql\/13\/data\/\r\npg1-user=postgres<\/pre>\nTo take a backup with pgBackrest, we must first create the backup catalog. After creating, we check the correctness of the operation we have done.<\/p>\n
$ pgbackrest --stanza=demo --log-level-console=info stanza-create\r\n$ pgbackrest --stanza=demo --log-level-console=info check<\/pre>\nAfter checking, we can get a full backup with the following command.<\/p>\n
$ pgbackrest --stanza=demo --log-level-console=info backup<\/pre>\nDifferential backup:<\/h5>\n
$ pgbackrest --stanza=demo --type=diff --log-level-console=info backup<\/pre>\nIncremental backup:<\/h5>\n
$ pgbackrest --stanza=demo --type=incr --log-level-console=info backup<\/pre>\nWe can use the following command to get information about the previously taken backups.<\/p>\n
$ pgbackrest info<\/pre>\nBackup Restore<\/h5>\n
For full backup restore, we must first stop the postgresql service. After performing the restore process, we can start the service again.<\/p>\n
[root@testdb ~]systemctl stop postgresql-13\r\n$ pgbackrest --stanza=demo --delta restore\r\n[root@testdb ~]systemctl start postgresql-13<\/pre>\nIncremental backup restore:<\/h5>\n
[root@testdb ~]systemctl stop postgresql-13\r\n$ pgbackrest --stanza=demo --delta restore \\ \r\n --recovery-option=recovery_target=immediate\r\n[root@testdb ~]systemctl start postgresql-13<\/pre>\nI hope it will be a useful document for you.<\/p>\n
<\/div>\n