0 Comments

Configure pgbackrest on Backup Host – Remote in PostgreSQL 5 (1)

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, […]

 432 Total Views

0 Comments

Configure pgbackrest on Database Server – Local in PostgreSQL 0 (0)

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 […]

 248 Total Views,  1 Views Today

0 Comments

Physical PostgreSQL Backup using BARMAN 0 (0)

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 […]

 229 Total Views

0 Comments

Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux) 0 (0)

Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux) In a recent blog, we demonstrated Step by Step Install Linux 8 (OEL) along with Guest Addition, in this article, we will perform Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux).  To upgrade OEL 8.2 to 8.4, we will be using […]

 549 Total Views

0 Comments

Install and Configure BARMAN for PostgreSQL 5 (1)

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) […]

 1,366 Total Views,  1 Views Today

6 Comments

Physical PostgreSQL Backup using pg_basebackup 0 (0)

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 […]

 590 Total Views,  1 Views Today

2 Comments

Physical PostgreSQL Backup 4 (1)

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 […]

 238 Total Views

0 Comments

Logical PostgreSQL Backup – Import 0 (0)

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 […]

 277 Total Views

0 Comments

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation 0 (0)

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation In this article we will solve error [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’.  Above error occurred while 19c (19.3) binary installation on server Oracle enterprise Linux version (OEL) 8.2 or greater than version 8.1 i.e Oracle 19c supported up to version […]

 624 Total Views

0 Comments

Logical PostgreSQL Backup – Export 0 (0)

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) […]

 185 Total Views