To take a full database backup with PGBackRest, you can use the pgbackrest backup command. Here are the general steps:
-
Make sure you have a valid PGBackRest configuration file (
pgbackrest.conf) that specifies the database to back up and the backup storage location. -
Run the following command to perform a full backup:
pgbackrest backup --type=full --db-include=<database_name> --target=<backup_directory>
3. This command creates a full backup of the specified database and stores it in the backup storage location specified in the configuration file. The --type=full option specifies that a full backup should be taken.
4.Monitor the backup progress by looking at the output of the command. PGBackRest provides detailed information about the backup progress, including the size of the backup, the number of files being backed up, and the backup speed.
5.Once the backup is complete, you can verify it by running the pgbackrest info command. This command displays information about the available backups, including the type of backup, the backup size, and the backup timestamp.
Note that these are general steps, and the exact command and options may differ depending on your specific needs and environment. For more detailed instructions and examples, you can refer to the PGBackRest documentation.
PGBackRest backup for multiple Databases
To take a backup of multiple databases with PGBackRest, you can use the --db-include option to specify a comma-separated list of database names. Here are the general steps:
-
Make sure you have a valid PGBackRest configuration file (
pgbackrest.conf) that specifies the databases to back up and the backup storage location. -
Run the following command to perform a full backup of multiple databases:
pgbackrest backup --type=full --db-include=<database1>,<database2>,<database3> --target=<backup_directory>
-
Replace
<database1>,<database2>,<database3>with a comma-separated list of the database names you want to back up, and<backup_directory>with the directory where you want to store the backup. The--type=fulloption specifies that a full backup should be taken. -
Monitor the backup progress by looking at the output of the command. PGBackRest provides detailed information about the backup progress, including the size of the backup, the number of files being backed up, and the backup speed.
-
Once the backup is complete, you can verify it by running the
pgbackrest infocommand. This command displays information about the available backups, including the type of backup, the backup size, and the backup timestamp.
Note that these are general steps, and the exact command and options may differ depending on your specific needs and environment. For more detailed instructions and examples, you can refer to the PGBackRest documentation.
