Posts by Marimuthu Pandu

Step-by-Step Guide: Configure Debezium with PostgreSQL 17 and Apache Kafka

Prerequisites  PostgreSQL 17 installed and running. • Java 11 or later installed. • Apache Kafka and Kafka Connect. • Debezium PostgreSQL connector JAR placed in Kafka Connect plugin path. • A PostgreSQL…

Read More

Creating a MongoDB Database and User with Permissions

Connect to MongoDB usingmongosh To begin working with MongoDB, open your terminal and connect using the MongoDB shell (mongosh):  mongosh  Create a Database MongoDB creates databases implicitly when you first…

Read More

Apply ASM and Oracle Patch in Standalone Server

Apply ASM and Oracle Patch in Standalone Server  This detailed guide walks you through applying ASM and Oracle patches in a standalone server environment, from downloading patches to verifying successful…

Read More

WSO2 configuration

Table of Contents  Create User in Carbon URL  1.1 Assign Privileges to the Created User  1.2 Verify the Created User  Create API in Publisher URL  Get Token from Devportal URL …

Read More

Essential PostgreSQL Shortcut Commands for Efficient Database Management

Essential PostgreSQL Shortcut Commands for Efficient Database Management 📌 Master psql with these quick and powerful shortcut commands! Category: Database, PostgreSQL Tags: PostgreSQL, psql, database management, SQL commands Slug: postgresql-shortcut-commands…

Read More

Creating DBLink from MSSQL to ORACLE database schema

This document describes the process of creating a DBLink from an MSSQL database to an Oracle database schema  A database link (DBLink) allows seamless integration and access between two databases,…

Read More

Monitoring and Managing Streaming Replication in PostgreSQL

Streaming replication in PostgreSQL is a vital feature for ensuring data availability and redundancy. Once your primary and standby servers are set up, it’s essential to monitor the replication status…

Read More

PostgreSQL Master and Slave Configuration Guide: Implementing Streaming Replication

PostgreSQL’s streaming replication is a powerful feature that allows real-time data replication from a primary database server (master) to one or more standby servers (slaves). This guide will take you…

Read More

Rotate any logs with logrotated.services

                                                           …

Read More

How to install POSTGRESQL and PGADMIN on linux 7 (REDHAT,CENTOS,ORACLE LINUX)

  INTRODUCTION:  This doc will guide you through the process of installing Postgresql14, Pgadmin4 and also Creating users, databases, schemas VERSION: PostgreSQL14 PGAdmin-4 Verify Platform compatibility  using below link https://www.enterprisedb.com/resources/platform-compatibility…

Read More