2 Comments

Important Technical Links Powered by DBsGuru 5 (4)

Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are […]

 3,335 Total Views,  1 Views Today

0 Comments

Install and Configure pg_repack in PostgreSQL 0 (0)

Install and Configure pg_repack in PostgreSQL pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance […]

 24 Total Views,  3 Views Today

0 Comments

Install and Configure pgBadger in PostgreSQL Part-II 0 (0)

Install and Configure pgBadger in PostgreSQL Part-II This article is a continuation of the Installed pgBadger package in PostgreSQL click here to read more. In this blog, we will Configure PostgreSQL Cluster to use pgBadger. Since pgbadger reads the PostgreSQL logs and picks up the information, it is essential to make some changes on postgresql.conf […]

 29 Total Views

0 Comments

Oracle Critical Database Patch ID for October 2021 0 (0)

Oracle Critical Database Patch ID for October 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch […]

 101 Total Views,  14 Views Today

0 Comments

Install and Configure pgBadger in PostgreSQL Part-I 0 (0)

Install and Configure pgBadger in PostgreSQL Part-I pgBadger is a PostgreSQL log analyzer built for speed providing fully detailed reports based on your PostgreSQL log files.                                                           […]

 33 Total Views

0 Comments

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade 0 (0)

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade Current PostgreSQL version numbers consist of a major and a minor version number. For example, in version number 13.1, where 13 is the major version number and 1 is the minor version number. pg_upgrade is a utility to upgrade PostgreSQL Cluster to major version eg 10.7 to 11.2 or 12.1 to 13.4. pg_upgrade […]

 71 Total Views

0 Comments

PostgreSQL minor version upgrade from 13.1 to 13.4 0 (0)

PostgreSQL minor version upgrade from 13.1 to 13.4 Current PostgreSQL version numbers consist of a major and a minor version number. For example, in version number 13.1, where 13 is the major version number and 1 is the minor version number. Minor releases never change the internal storage format and are always compatible with earlier […]

 106 Total Views,  2 Views Today

0 Comments

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) 0 (0)

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on PostgreSQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow […]

 102 Total Views

0 Comments

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0)

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental and differential Level 1 (L1) database backup which includes backup of datafiles (L1), control files, spfile along with archives. RMAN incremental backups back up only datafile blocks that have changed since […]

 131 Total Views,  1 Views Today

0 Comments

Steps to Setup Database Link in PostgreSQL 0 (0)

Steps to Setup Database Link in PostgreSQL Database Link in PostgreSQL enables a database user to access a table present on a different PostgreSQL cluster. It provides a functionality in PostgreSQL similar to that of DB Link in Oracle, Linked Server in SQL Server and Federated Table in MySQL. In previous post we saw How to […]

 198 Total Views,  2 Views Today

0 Comments

Steps to Setup a Foreign Data Wrapper(postgres_fdw) in PostgreSQL 0 (0)

Steps to Setup a Foreign Data Wrapper(postgres_fdw) in PostgreSQL A foreign data wrapper (postgres_fdw) is an extension available in PostgreSQL that allows you to access a table or schema in one PostgreSQL database from another PostgreSQL DB. For this demonstration, we’ll use the databases local_db and remote_db. We will access a table employee in remote_db […]

 173 Total Views,  2 Views Today