Hi Team,

As requested, I’ve collated the key KB articles and Confluence documents essential for understanding PostgreSQL. Please find the relevant links and documents below for your reference and further use in Polestar integration.

Let me know if anything additional is needed.

Thanks,
[Your Name]

Posted By Nikhil03:07

0

Continue Reading

 I’d like to schedule a quick walkthrough/KT session with you.

This will help me understand the current setup, priorities, and where to begin effectively.

Posted By Nikhil05:39

0

Continue Reading

 While the IB GBL patching targets were listed in the shared Excel, they were not formally communicated. I have initiated patching for the databases assigned to me and will continue to progress, considering my upcoming leave.

Posted By Nikhil22:09

0

Continue Reading

 #!/bin/bash

# Usage: ./compare_oracle_patches.sh <OLD_ORACLE_HOME> <NEW_ORACLE_HOME>

OLD_HOME=$1

NEW_HOME=$2

if [[ -z "$OLD_HOME" || -z "$NEW_HOME" ]]; then

  echo "Usage: $0 <OLD_ORACLE_HOME> <NEW_ORACLE_HOME>"

  exit 1

fi

echo "🔍 Comparing patches..."

echo "Old Home: $OLD_HOME"

echo "New Home: $NEW_HOME"

echo "----------------------------------------"

# Temp files

OLD_FILE=$(mktemp)

NEW_FILE=$(mktemp)

# Extract patch list

$OLD_HOME/OPatch/opatch lsinventory | grep "Patch" | sort > $OLD_FILE

$NEW_HOME/OPatch/opatch lsinventory | grep "Patch" | sort > $NEW_FILE

echo "📌 Patches ONLY in OLD (Bespoke Home):"

comm -23 $OLD_FILE $NEW_FILE

echo ""

echo "📌 Patches ONLY in NEW (Standard Home):"

comm -13 $OLD_FILE $NEW_FILE

echo ""

echo "📌 Common patches:"

comm -12 $OLD_FILE $NEW_FILE

# Cleanup

rm -f $OLD_FILE $NEW_FILE

echo "----------------------------------------"

echo "✅ Comparison complete"

Posted By Nikhil18:14

0

Continue Reading

 /dbs/2025_Q2_F1/OPatch/opatch lsinventory | grep "Patch" | sort > old.txt

/dbs/2026_Q1_V1/OPatch/opatch lsinventory | grep "Patch" | sort > new.txt

diff old.txt new.txt

comm -3 \

<( /dbs/2025_Q2_F1/OPatch/opatch lsinventory | grep "Patch" | sort ) \

<( /dbs/2026_Q1_V1/OPatch/opatch lsinventory | grep "Patch" | sort )

Posted By Nikhil18:10

0

Continue Reading

 SELECT 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ''' IMMEDIATE;'

FROM v$session

WHERE <your_condition>;

Posted By Nikhil22:33

0

Continue Reading

Hi all, I’ve proposed an idea to reduce delays in TPAC/TPAI approval using automated notifications.

Do check it out and drop a vote if you like it 👍

Posted By Nikhil18:16

0

Continue Reading