Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)

by

Create CNPG Directory & postgres.yaml Manifest —————————————————————– Create a directory for CNPG configuration and add the postgres.yaml file: vi postgres.yaml —————————————————————–Cluster 1 — app-db-cluster (Application Database)—————————————————————–apiVersion: postgresql.cnpg.io/v1kind: Clustermetadata:  name: app-db-cluster  namespace: prod-databasespec:  instances: 2  imageName: ghcr.io/cloudnative-pg/postgresql:16.2  affinity:    nodeSelector:      role: “database”    tolerations:      – key: “database”        operator: “Equal”        value: “true”        effect: “NoSchedule”  bootstrap:    initdb:      database: appdb      owner: … Read more

Installation of Kubernetes -k3s

by

Master Worker Master Node Taint and label Install helm To use the inbuilt registries Install AWS ClI to pull images Pull Images sh get_images.sh check images [rocky@k3s-master ~]$ sudo /usr/local/bin/ctr -a /var/run/k3s/containerd/containerd.sock -n k8s.io image check | grep -i local | awk ‘{print $1}’ Worker Node Create PV and VG Configuire EBS Ingress Controller Deploy … Read more

CNPG Disk Error

by

Fixing CNPG PostgreSQL CrashLoopBackOff: A Deep Dive into PVC Resize Failure & Disk Pressure on OpenEBS LVM LocalPV A Real-World Production Issue & How We Resolved It In this article, I’ll walk you through a production-grade debugging scenario where our CloudNativePG (CNPG) PostgreSQL cluster went into a full outage. Both the primary and replica pods … Read more

Categories ASM

Resync Standby Database Using RMAN Incremental Backups

by

Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human error, the archives has been deleted from primary. So without those archives, standby can’t be in sync with primary. So when this situation occurs, … Read more

Step by Step Data Guard Configuration in 19c

by

1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11 we need to install the BINARIES OF ORACLE 19c and then create only 1 PRIMARY DB NAMED ORCL by using ./dbca or manually as required. 2) In STANDBY SERVER DG11S we only need to install the BINARIES OF ORACLE 19c. … Read more

Switchover to Physical Standby Database in Oracle !!

by

Once the standby database is configured and verified to be working properly, we can switch over to the standby database for testing purposes. This helps to minimize downtime for the primary database, which may be required for various maintenance tasks such as OS upgrades, hardware upgrades, and other issues.During a switchover from the primary database … Read more

2 node RAC with Dataguard Configuration (DGMGRL)

by

This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data Broker configuration in a Primary and Physical Standby environment for high availability. You need to download the following software if you do not have already. We can see here 6 redo … Read more

Step by Step Oracle Database 23ai Installation on Oracle Linux 8.10 !!

by

Oracle Database 23ai is the next long-term support release of Oracle Database. It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity. Oracle Database 23ai also uses AI to optimize many of the key database functions to make more accurate estimates on timings and resource costings. Oracle Database Free … Read more

Create Pluggable Database (PDB) Manually Using SQL Prompt Oracle 19c !!

by

Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks: Prerequisites You must be connected to a CDB. The CDB must be open and in READ WRITE mode. To create a PDB or an application container, the current container must be the root and you must have the CREATE PLUGGABLE DATABASE system privilege, granted commonly. … Read more