0 Comments

Access MySql database from PostgreSQL using MySQL Foreign Data Wrapper (MYSQL_FDW) 0 (0)

Access MySQL database from PostgreSQL using MySql Foreign Data Wrapper (MYSQL_FDW) The MySQL Foreign Data Wrapper (mysql_fdw) is a Postgres extension that allows you to access data that resides on a MySQL database from Postgres Server. It is a writeable foreign data wrapper that you can use with Postgres functions and utilities, or in conjunction […]

 261 Total Views,  5 Views Today

0 Comments

Configure and monitor using pg_profile in PostgreSQL 0 (0)

Configure and monitor using pg_profile in PostgreSQL This extension for PostgreSQL helps you to find out the most resource-consuming activities in your PostgreSQL databases. Extension is based on statistic views of PostgreSQL and contrib extension pg_stat_statements. A historic repository will be created in your database by this extension. This repository will hold statistic “samples” for your […]

 397 Total Views,  2 Views Today

0 Comments

Monitor PostgreSQL Cluster using pgCenter 0 (0)

Monitor PostgreSQL Cluster using pgCenter pgCenter is a command-line admin tool for observing and troubleshooting PostgreSQL i.e monitor PostgreSQL cluster. Postgres provides various activity statistics about its runtime, such as connections, statements, database operations, replication, resources usage, and more. The general purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres. However, […]

 215 Total Views,  2 Views Today

0 Comments

Install and Configure pg_repack in PostgreSQL 5 (1)

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

 685 Total Views,  18 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 […]

 363 Total Views,  5 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.                                                           […]

 360 Total Views,  3 Views Today

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

 532 Total Views,  5 Views Today

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

 655 Total Views,  11 Views Today

0 Comments

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

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

 512 Total Views,  4 Views Today

0 Comments

Steps to Setup Database Link in PostgreSQL 4 (1)

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

 1,279 Total Views,  14 Views Today