Replication mechanism is not a bacl\u0131up method!<\/p>\n
pgBackRest software is classified as \u201cphysical backup \/ restore\u201d.<\/p>\n
What can you do with pgBackRest?<\/h3>\n\n- You can create backups on the same server or on a different server.<\/li>\n
- You can create a backup from Replication. pgBackRest allows you to create backups on a backup server connected with master and replica. pgBackRest backs up data that is not available in Replica from the master. All remaining backup operations are performed from Replica. Thus, you do not create a backup cost on the master server.<\/li>\n
- You can perform all backup and restore operations in parallel.<\/li>\n
- pgBackRest compresses and sends data when creating backups. Thus, you do not overload the network traffic. This makes backup\/restore faster.<\/li>\n
- pgBackRest maintains a catalog of backups;<\/li>\n<\/ul>\n
Time Information
\nSize Information
\nRequired segment files
\nBackup type<\/p>\n
\n- pgBackRest has 3 backup types.<\/li>\n<\/ul>\n
PgBackRest Backup Types<\/h4>\n
Full backup: All data in the PostgreSQL Cluster is backed up.<\/p>\n
Differential backup: Backups files that have changed from the last full backup.<\/p>\n
Incremental backup: Backups the files that have changed from the last backup.<\/p>\n
\n- pgBackRest tracks wal files. It uses the archive_command parameter in Postgresql.conf. It deletes old backups and old wal files. Incremental backups related to full and diff backups are also automatically deleted.<\/li>\n
- pgBackRest stores the number of full and differential backups you specify.<\/li>\n
- pgBackRest supports PostgreSQL 12 with the latest version v2.18.<\/li>\n<\/ul>\n
PgBackRest Installation<\/h1>\n
In this section, we will install PgBackRest and create backups with pgBackRest in the following ways.<\/p>\n
\n- Create PostgreSQL Cluster Backup with pgBackRest on the Same Server<\/li>\n
- Create PostgreSQL Cluster Backup with pgBackRest to Backup Server<\/li>\n
- Create PostgreSQL Cluster Backup From Replication with pgBackRest<\/li>\n<\/ul>\n
First, according to the architecture you choose, we install pgBackrest on the PostgreSQL server and\/or on all servers where the backup we create is stored:<\/p>\n
Install PgBackRest on Debian and its derivatives<\/h3>\nsudo apt-get install pgbackrest<\/pre>\nInstall PgBackRest on RedHat and its derivatives<\/h3>\nsudo yum install pgbackrest.x86_64<\/pre>\nPgBackRest uses archive_mode and archive_command in postgresql.conf to track wal. We set these parameters on all database servers.<\/p>\n
Change Parameters on postgresql.conf to Track WALs<\/h3>\narchive_mode = on\narchive_command = 'pgbackrest --stanza=12_data archive_push %p'<\/pre>\nBy connecting to PostgreSQL, you can do the same with the following commands;<\/p>\n
ALTER SYSTEM SET archive_mode = on;\nALTER SYSTEM SET archive_command = 'pgbackrest --stanza=12_data archive_push %p';<\/pre>\nRestart PostgreSQL to enable the change to the archive_mode parameter.<\/p>\n
systemctl restart postgresql-12<\/pre>\nCreate PostgreSQL Cluster Backup with pgBackRest on the Same Server<\/h3>\n
If you want to create a backup on the master server,<\/p>\n
Configuration of pgBackRest<\/h4>\n$ cat \/etc\/pgbackrest.conf\n[global]\nrepo-path=\/pg_backup\/12\/data\/pgbackrest\nbackup-user=postgres\nretention-full=3\nretention-diff=2\nprocess-max=2\nlog-path=\/pg_backup\/12\/data\/log\/pgbackrest\n\n\n[12_data]\npg1-path=\/var\/lib\/pgsql\/12\/data\/<\/pre>\nCreate PostgreSQL Cluster Backup with pgBackRest to Backup Server<\/h3>\n
If you want to create a backup to backup server,<\/p>\n
Configuration of pgBackRest on Master<\/h4>\n$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-host=Backup_Server_IP\nrepo1-host-user=postgres\n\n[12_data]\npg1-path=\/var\/lib\/pgsql\/12\/data\/<\/pre>\nConfiguration of pgBackRest on Backup Server<\/h4>\n$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-path=\/pg_backup\/12\/data\/pgbackrest\nrepo1-retention-full=3\nrepo1-retention-diff=2\nprocess-max=2\n\n[12_data]\npg1-host=Master_Server_IP\npg1-path=\/var\/lib\/pgsql\/12\/data\/\npg1-user=postgres<\/pre>\nCreate PostgreSQL Cluster Backup From Replication with pgBackRest<\/h3>\n
In this scenario, we will create a backup from Replika to backup server.<\/p>\n
Configurations of pgbackrest on Master and Replica<\/h4>\n$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-path=\/pg_backup\/12\/data\/pgbackrest\nrepo1-retention-full=3\nrepo1-retention-diff=2\nprocess-max=2\n\n[12_data]\npg1-host=Master_Server_IP\npg1-path=\/var\/lib\/pgsql\/12\/data\/\npg1-user=postgres<\/pre>\nConfiguration of pgBackRest on Backup Server<\/h4>\n$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-path=\/pg_backup\/12\/data\/pgbackrest\nrepo1-retention-full=3\nrepo1-retention-diff=2\nprocess-max=2\nbackup-standby=y\n\n[12_data]\npg1-host=Master_Server_IP\npg1-path=\/var\/lib\/pgsql\/12\/data\/\npg1-user=postgres\npg2-host=Replica_Server_IP\npg2-path=\/var\/lib\/pgsql\/12\/data\/\npg2-user=postgres<\/pre>\nBackup PostgreSQL Cluster with PgBackRest<\/h1>\nCheck PgBackRest Configurations<\/h3>\n
We need to create a backup catalog first. Next, we need to check that the pgBackRest configurations are correct.<\/p>\n
$ pgbackrest --stanza=12_data stanza-create --log-level-console=info\n$ pgbackrest --stanza=12_data check --log-level-console=info<\/pre>\nWe can create a backup \ud83d\ude42<\/p>\n
$ pgbackrest --stanza=12_data backup --log-level-console=info<\/pre>\npgBackRest creates a full backup by default on the first backup. You can specify the backup type with –type(full, diff, or incr).<\/p>\n
$ pgbackrest --stanza=12_data --type=backup_type_you_want_to_create backup<\/pre>\nThe sample command and output are as follows:<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-106.png\")
<\/p>\n
List the backup catalog and the backups<\/h3>\n$ pgbackrest --stanza=12_data info<\/pre>\n![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-107.png\")
<\/p>\n
Restore PostgreSQL Cluster with PgBackRest<\/h1>\n
When the PostgreSQL service is closed on the server we want to restore, we run the following command:<\/p>\n
$ pgbackrest --stanza=12_data restore<\/pre>\npgBackRest returns the most recent backup by default.<\/p>\n
In this article I talked about backing up with basic-level configurations.<\/p>\n
<\/div>\n
Time Information
\nSize Information
\nRequired segment files
\nBackup type<\/p>\n
- \n
- pgBackRest has 3 backup types.<\/li>\n<\/ul>\n
PgBackRest Backup Types<\/h4>\n
Full backup: All data in the PostgreSQL Cluster is backed up.<\/p>\n
Differential backup: Backups files that have changed from the last full backup.<\/p>\n
Incremental backup: Backups the files that have changed from the last backup.<\/p>\n
- \n
- pgBackRest tracks wal files. It uses the archive_command parameter in Postgresql.conf. It deletes old backups and old wal files. Incremental backups related to full and diff backups are also automatically deleted.<\/li>\n
- pgBackRest stores the number of full and differential backups you specify.<\/li>\n
- pgBackRest supports PostgreSQL 12 with the latest version v2.18.<\/li>\n<\/ul>\n
PgBackRest Installation<\/h1>\n
In this section, we will install PgBackRest and create backups with pgBackRest in the following ways.<\/p>\n
- \n
- Create PostgreSQL Cluster Backup with pgBackRest on the Same Server<\/li>\n
- Create PostgreSQL Cluster Backup with pgBackRest to Backup Server<\/li>\n
- Create PostgreSQL Cluster Backup From Replication with pgBackRest<\/li>\n<\/ul>\n
First, according to the architecture you choose, we install pgBackrest on the PostgreSQL server and\/or on all servers where the backup we create is stored:<\/p>\n
Install PgBackRest on Debian and its derivatives<\/h3>\n
sudo apt-get install pgbackrest<\/pre>\n
Install PgBackRest on RedHat and its derivatives<\/h3>\n
sudo yum install pgbackrest.x86_64<\/pre>\n
PgBackRest uses archive_mode and archive_command in postgresql.conf to track wal. We set these parameters on all database servers.<\/p>\n
Change Parameters on postgresql.conf to Track WALs<\/h3>\n
archive_mode = on\narchive_command = 'pgbackrest --stanza=12_data archive_push %p'<\/pre>\n
By connecting to PostgreSQL, you can do the same with the following commands;<\/p>\n
ALTER SYSTEM SET archive_mode = on;\nALTER SYSTEM SET archive_command = 'pgbackrest --stanza=12_data archive_push %p';<\/pre>\n
Restart PostgreSQL to enable the change to the archive_mode parameter.<\/p>\n
systemctl restart postgresql-12<\/pre>\n
Create PostgreSQL Cluster Backup with pgBackRest on the Same Server<\/h3>\n
If you want to create a backup on the master server,<\/p>\n
Configuration of pgBackRest<\/h4>\n
$ cat \/etc\/pgbackrest.conf\n[global]\nrepo-path=\/pg_backup\/12\/data\/pgbackrest\nbackup-user=postgres\nretention-full=3\nretention-diff=2\nprocess-max=2\nlog-path=\/pg_backup\/12\/data\/log\/pgbackrest\n\n\n[12_data]\npg1-path=\/var\/lib\/pgsql\/12\/data\/<\/pre>\n
Create PostgreSQL Cluster Backup with pgBackRest to Backup Server<\/h3>\n
If you want to create a backup to backup server,<\/p>\n
Configuration of pgBackRest on Master<\/h4>\n
$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-host=Backup_Server_IP\nrepo1-host-user=postgres\n\n[12_data]\npg1-path=\/var\/lib\/pgsql\/12\/data\/<\/pre>\n
Configuration of pgBackRest on Backup Server<\/h4>\n
$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-path=\/pg_backup\/12\/data\/pgbackrest\nrepo1-retention-full=3\nrepo1-retention-diff=2\nprocess-max=2\n\n[12_data]\npg1-host=Master_Server_IP\npg1-path=\/var\/lib\/pgsql\/12\/data\/\npg1-user=postgres<\/pre>\n
Create PostgreSQL Cluster Backup From Replication with pgBackRest<\/h3>\n
In this scenario, we will create a backup from Replika to backup server.<\/p>\n
Configurations of pgbackrest on Master and Replica<\/h4>\n
$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-path=\/pg_backup\/12\/data\/pgbackrest\nrepo1-retention-full=3\nrepo1-retention-diff=2\nprocess-max=2\n\n[12_data]\npg1-host=Master_Server_IP\npg1-path=\/var\/lib\/pgsql\/12\/data\/\npg1-user=postgres<\/pre>\n
Configuration of pgBackRest on Backup Server<\/h4>\n
$ cat \/etc\/pgbackrest.conf\n[global]\nrepo1-path=\/pg_backup\/12\/data\/pgbackrest\nrepo1-retention-full=3\nrepo1-retention-diff=2\nprocess-max=2\nbackup-standby=y\n\n[12_data]\npg1-host=Master_Server_IP\npg1-path=\/var\/lib\/pgsql\/12\/data\/\npg1-user=postgres\npg2-host=Replica_Server_IP\npg2-path=\/var\/lib\/pgsql\/12\/data\/\npg2-user=postgres<\/pre>\n
Backup PostgreSQL Cluster with PgBackRest<\/h1>\n
Check PgBackRest Configurations<\/h3>\n
We need to create a backup catalog first. Next, we need to check that the pgBackRest configurations are correct.<\/p>\n
$ pgbackrest --stanza=12_data stanza-create --log-level-console=info\n$ pgbackrest --stanza=12_data check --log-level-console=info<\/pre>\n
We can create a backup \ud83d\ude42<\/p>\n
$ pgbackrest --stanza=12_data backup --log-level-console=info<\/pre>\n
pgBackRest creates a full backup by default on the first backup. You can specify the backup type with –type(full, diff, or incr).<\/p>\n
$ pgbackrest --stanza=12_data --type=backup_type_you_want_to_create backup<\/pre>\n
The sample command and output are as follows:<\/p>\n
<\/p>\nList the backup catalog and the backups<\/h3>\n
$ pgbackrest --stanza=12_data info<\/pre>\n
<\/p>\nRestore PostgreSQL Cluster with PgBackRest<\/h1>\n
When the PostgreSQL service is closed on the server we want to restore, we run the following command:<\/p>\n
$ pgbackrest --stanza=12_data restore<\/pre>\n
pgBackRest returns the most recent backup by default.<\/p>\n
In this article I talked about backing up with basic-level configurations.<\/p>\n
<\/div>\n