DBsGuru

Install and Configure BARMAN for PostgreSQL

June 23, 2021

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…

📌

0💬 read more

Physical PostgreSQL Backup using pg_basebackup

June 21, 2021

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…

📌

6💬 read more

Physical PostgreSQL Backup

June 18, 2021

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…

📌

2💬 read more

Logical PostgreSQL Backup – Import

June 16, 2021

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…

📌

0💬 read more

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

June 15, 2021

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…

📌

4💬 read more

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…

📌

0💬 read more

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility

June 13, 2021

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility Upgrading a database is always a big task for DBAs in this world but this time Oracle introduces a new…

📌

6💬 read more

Similarities Between Oracle and PostgreSQL

June 11, 2021

Similarities Between Oracle & PostgreSQL In this blog, we will compare similarities between Oracle & PostgreSQL in terms of Memory, Process, Files, General architecture, etc. COMPONENTS ORACLE POSTGRESQL Architecture: Memory…

📌

5💬 read more

Solution for OGG-00516 Fatal error executing DDL replication in Oracle Goldengate

June 10, 2021

Solution for OGG-00516 Fatal error executing DDL replication in Oracle Goldengate In this blog, we will perform a solution to resolve OGG-00516 Fatal error executing DDL replication.This error occurs when…

📌

4💬 read more

Tablespaces in PostgreSQL

June 9, 2021

Tablespaces in PostgreSQL A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such as tables and indexes) can reside….

📌

4💬 read more