For BACKUP & RECOVERY articles under category MySql.
Restore Backup using pg_basebackup in PostgreSQL In this blog, we will see How to perform a restore of a backup taken from pg_basebackup. We will see full steps for the below two scenarios: 1. Restore in the same directory structure of the backup database.2. Restore in the different directory structures of the backup database. For
Physical Backup using pgBackRest in PostgreSQL In the previous blog, we have demonstrated Configure pgbackrest on Backup Host – Remote in Backup Server Click here to read more. In this blog, we will use the pgbackrest tool to take different types of database backup. pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable
Configure pgbackrest on Backup Host – Remote in PostgreSQL In the previous blog, we demonstrated How to install pgbackrest on Database Server – Local in PostgreSQL Click here to read more. Such setups are not used in a production environment to perform the backup on the same server where the database is running. In this blog,
Configure pgbackrest on Database Server – Local in PostgreSQL pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable backups. pgBackRest is a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms optimized for database-specific requirements. Some of the key
Physical PostgreSQL Backup using BARMAN In the previous blog, we have demonstrated Install & Configured barman tool in Backup Server Click here to read more. In this blog, we will use barman tool to take database backups. List available servers: Use command barman list-server to get the list configured server in barman. Show configured parameters: Use
Install and Configure BARMAN for PostgreSQL BARMAN (Backup and Recovery Manager) is an open-source administration tool for backup and disaster recovery of PostgreSQL servers. It allows performing remote backups of multiple servers. Following are barman features. 1) Open Source Tool. 2) Remote backup and restore of multiple Servers. 3)
Physical PostgreSQL Backup using pg_basebackup pg_basebackup is used to take base backups of a running PostgreSQL database cluster. It Can be used both for point-in-time recovery and as the starting point for log shipping or streaming replication standby servers. pg_basebackup makes a binary copy of the database cluster files while making sure the system is
Physical PostgreSQL Backup Is file system-level copy of files that comprise the database cluster can be either Offline or Online mode. Advantage : 1) Generally faster to backup and restore. 2) Allow Point-In-Time-Recovery PITR (If WAL are archived) 3) Full or Incremental backup. 4) Will allow DDL during backup. Disadvantage : 1) Lack of flexibility:- Backup/Restore entire DB Cluster. Selective
Logical PostgreSQL Backup – Import Logical (SQL DUMP) Database Backup (Export/Import) is an extract of some or all data or structure of objects within the database. This is a dump in the form of an SQL command that can be executed on the server in order to recreate database objects. Advantage:1) Flexibility: Dump files are OS-independent. 2) Cross Version Compatibility: Take backup from Higher Version and
Logical PostgreSQL Backup – Export Logical (SQL DUMP) Database Backup is an extract of some or all data or structure of objects within the database. This is a dump in the form of an SQL command that can be executed on the server in order to recreate database objects. Advantage:1) Flexibility: Dump files are OS-independent. 2)
