d

Installing and Configuring PGlogical Replication for Database: classicdba PGlogical is a PostgreSQL extension that provides logical streaming replication. It allows you to replicate data between PostgreSQL databases in a more flexible and fine-grained manner than physical replication. This guide will take you through the steps to install and configure PGlogical for the database classicdba. Installing…

Read More

PGlogical Replication Installing and Configuring.

Installing and Configuring PGlogical Replication for Database: classicdba PGlogical is a PostgreSQL extension that provides logical streaming replication. It allows you to replicate data between PostgreSQL databases in a more flexible and fine-grained manner than physical replication. This guide will take you through the steps to install and configure PGlogical for the database classicdba. Installing…

Read More

PgBadger Installation and Usage.

Installing pgBadger Step 1: Install Dependencies Ensure that you have the necessary dependencies installed. pgBadger requires Perl and a few Perl modules. Step 2: Download and Install pgBadger Download the latest version of pgBadger from its official repository. Step 3: Verify Installation Confirm that pgBadger has been installed correctly by checking its version. Configuring PostgreSQL…

Read More

PostgreSQL Installation Using Source Code.

Introduction Installing PostgreSQL on Ubuntu 22 using source code is a more hands-on approach that allows for greater customization and control over the installation process. This guide will walk you through each step, from preparation to configuration, ensuring a smooth installation and setup of PostgreSQL on your Ubuntu system. Understanding PostgreSQL What is PostgreSQL? PostgreSQL…

Read More

PostgreSQL Database Introduction

Understanding PostgreSQL What is PostgreSQL? PostgreSQL is an advanced, open-source relational database management system (RDBMS) known for its robustness, scalability, and support for complex queries and large datasets. It is widely used in various applications, from small single-machine setups to large internet-facing applications with many concurrent users. Key Features of PostgreSQL ACID Compliance: Ensures reliable…

Read More

PG_Logical_Troubleshooting:

Pglogical Replication Trouble shooting: in general as we complete setting up pglogical replication we need to monitor the replication from source to target database. Below Queries will Help to identify the Replication Progress and Status. Topics Covered. List Tables Registered in Pglogical How much GB we are behind from source to target. How much GB…

Read More

linux-dba-commands

OS commands for DBA As a Database Administrator (DBA), you may need to interact with the operating system (OS) to perform various tasks related to managing databases. Here are some common OS commands used by DBAs: 1. RAM SIZEĀ 2. Find3. SAR4. vmstat5. iostat6. swap7. uptime8. Top CPU users9. Top memory users10. Check disk space11. TOP…

Read More

Pglogical Replication

What is pglogical? pglogical is an extension for PostgreSQL that provides logical replication capabilities. It allows you to replicate data changes (inserts, updates, deletes) at the row level between PostgreSQL databases. Unlike physical replication, which replicates at the block level, logical replication works at a higher level, replicating changes based on database objects (tables, schemas)…

Read More