Hello and welcome to DBsGuru,I’m Jamsher Khan working as Senior Oracle DBA based in KSA-Jeddah, I have working experience in Oracle DBA, SQL Server, MySql, PostgreSQL, Linux, Golden Gate, ODA.Thanks for the visits!Share Learn Grow!

  • Role: author
  • Number of posts: 140
  • Registration Date: December 16, 2020
  • Website: https://dbsguru.com

Last comments from Jamsher Khan

Posts by Jamsher Khan

Perform Mysql Physical Backup using Percona Xtrabackup 0 (0)

November 18, 2021

Perform Mysql Physical Backup using Percona Xtrabackup The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open…

Loading

📌
0💬 read more

Steps to enable HugePages in PostgreSQL 0 (0)

Steps to enable HugePages in PostgreSQL By default, the page size on Linux is 4kb. A typical PostgreSQL instance may allocate many GBs of memory, which will end up with…

Loading

📌
0💬 read more

Steps to Install Percona XtraBackup for MySQL 0 (0)

November 15, 2021

Steps to Install Percona XtraBackup for MySQL The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup…

Loading

📌
0💬 read more

Configure and monitor using pg_profile in PostgreSQL 0 (0)

November 9, 2021

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…

Loading

📌
0💬 read more

Monitor PostgreSQL Cluster using pgCenter 0 (0)

October 27, 2021

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…

Loading

📌
0💬 read more

Install and Configure pg_repack in PostgreSQL 5 (2)

October 24, 2021

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…

Loading

📌
1💬 read more

Install and Configure pgBadger in PostgreSQL Part-II 0 (0)

October 23, 2021

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…

Loading

📌
0💬 read more

Install and Configure pgBadger in PostgreSQL Part-I 5 (1)

October 22, 2021

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.        …

Loading

📌
0💬 read more

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade 0 (0)

October 16, 2021

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…

Loading

📌
0💬 read more

PostgreSQL minor version upgrade from 13.1 to 13.4 5 (2)

October 12, 2021

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…

Loading

📌
0💬 read more