Point in Time Recovery (PITR) using pg_basebackup in PostgreSQL
Point in Time Recovery (PITR) using pg_basebackup in PostgreSQL In previous blog we saw How to perform Full recovery using backup taken from pg_basebackup Click here to read more. In this blog we will see How to perform PITR using backup taken from pg_basebackup in PostgreSQL. For the purpose of demonstration we will be using our second
Restore Backup using pg_basebackup in PostgreSQL
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
How to Rename Database and DBID using DBNEWID in Oracle
Rename Database and DBID using DBNEWID in Oracle In this article, we are going to demonstrate rename of the database along with DBID using utility DBNEWID in Oracle. The question comes in mind why we require to rename DB? Whenever we do clone a database to a target (clone DB) server from the source (production
Physical Backup using pgBackRest in PostgreSQL
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
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
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
Install and Configure BARMAN for PostgreSQL
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)
Logical PostgreSQL Backup – Export
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)
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and