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

 23 Total Views,  2 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

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

 105 Total Views,  1 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

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

 197 Total Views,  1 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 […]

 171 Total Views

0 Comments

Steps to create a Database Link from Oracle to PostgreSQL 0 (0)

Steps to create a Database Link from Oracle to PostgreSQL Nowadays many companies are using a mix of RDBMS system 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 us […]

 192 Total Views

0 Comments

Setup Logical Replication using pglogical in PostgreSQL 0 (0)

Setup Logical replication using pglogical in PostgreSQL In the recent two blogs, we discuss built-in options like Streaming replication Click here to read more and Logical replication Click here to read more. In this blog, we will use pglogical extension to setup logical streaming replication for PostgreSQL. The pglogical extension provides logical streaming replication for PostgreSQL, using […]

 435 Total Views,  2 Views Today