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)
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 feature in 19c for an upgrade which is called “AutoUpgrade Utility” where we will upgrade a database from version 12c to 19c. Supported version for upgrade
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 Shared Global Area (SGA) Shared Memory DB buffer cache Shared buffer Log Buffer WAL (Write Ahead Log) Buffer Private Global Area (PGA) Work Memory Architecture:
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 the Oracle Goldengate REPLICATE process is unable to perform the same DDL on Target DB which was executed on Source DB. In the Target database,
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. The tablespace name must be distinct from the name of any existing tablespace in the database cluster. PostgreSQL uses a tablespace to map a logical
Vacuum and Autovacuum in PostgreSQL In this article, we will understand the detailed concept of Vacuum & Autovacuum along with practical examples of the same. Vacuum Whenever we run an UPDATE command, the system does not change the actual data, but it inserts new data in reference to the old data and mark the row
Configure WAL Archiving in PostgreSQL WAL is short for Write Ahead Log. In PostgreSQL terms, copying out generated WAL files is called archiving,If you save a copy of each WAL file that was generated, you could replay back the entire set of changes to another server. Saving all generated WAL files to a safe offline
How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application schema. To fulfill this request either we can grant SELECT privileges on all tables to requestor which are owned by specific application schema or create
Postgresql Architecture – Physical Storage Structure In this blog, we will discuss PostgreSQL architecture of physical storage which can be categorized in below four part: 1. Data Directory 2. Physical Files 3. Data file layout (OID) 4. Database Structure 1. Data Directory Specifies the directory to use for data storage. This parameter can only be
Postgresql Architecture – Process In the previous blog, we looked at Memory Components in PostgreSql, Click here to read more. In this post we will discuss the Process of PostgreSQL, Processes in PostgreSQL can be divided mainly into 4 types: 1. Postmaster (Daemon) Process 2. Background (Utility) Process 3. Backend Process 4. Client Process 1.
