Installing pgbadger on Linux for PostgreSQL log analysis

As a DBA, we often encounter scenarios when you need to track PostgreSQL database performance by analyzing workloads and identify bottlenecks if any. There comes pgbadger - an open source log analyzer for PostgreSQL. It parse the PostgreSQL log files and gives you a nice overview of the PostgreSQL cluster including various query metrics like … Continue reading Installing pgbadger on Linux for PostgreSQL log analysis

How to Recover a Database from Suspect or Recovery Pending State in SQL Server?

So one or more of your databases went into RECOVERY PENDING state or in SUSPECT mode and you are confused about what to do now in order to fix the issue immediately. Do not panic!! Almost every DBA has encountered this scenario quite a few times in their professional career where one or more databases … Continue reading How to Recover a Database from Suspect or Recovery Pending State in SQL Server?

How to Create an Amazon RDS Aurora PostgreSQL Database Cluster?

To keep up with the ever-changing and evolving tech industry, we want our databases to be easily scalable, replicable, fault tolerant, and most importantly without having any administrative hassle. One of the best options to achieve this is to opt for Amazon Relational Database Service (RDS). RDS supports a number of database engines and Amazon Aurora being one … Continue reading How to Create an Amazon RDS Aurora PostgreSQL Database Cluster?

Configuring PostgreSQL for the First Time

We have discussed the PostgreSQL installation steps here. Next comes the initial configuration part. We will separate the initial configuration into two steps: Enable Remote ConnectionsSet Server-Level Options Before we actually proceed further, let’s briefly discuss about the two most important PostgreSQL configuration file - pg_hba.conf and postgresql.conf, which we are going to modify soon … Continue reading Configuring PostgreSQL for the First Time

Installing PostgreSQL on Linux [CentOS] – A Step by Step Guide

PostgreSQL has earned a strong reputation of being the world's most advanced open source Relational database. Over the past few years it has seen a sharp rise in popularity as a Tier-1 RDBMS and more and more organizations are embracing PostgreSQL now a days. Moreover, it’s open-source, free to use, community-driven, without being owned by … Continue reading Installing PostgreSQL on Linux [CentOS] – A Step by Step Guide

How to troubleshoot high CPU utilization issue in SQL Server?

So you have received a high CPU utilization alert from your monitoring system and wondering what to do next. If yes, then this blog post may be helpful for you. You can follow the below steps to isolate the problem and mitigate it. Open task manager and identify if SQL Server process is causing the … Continue reading How to troubleshoot high CPU utilization issue in SQL Server?

How to check SQL Server Database Backup History for a server

One key responsibility of a database administrator is to ensure that a database backup is readily available to recover a database quickly(maintaining RPO & RTO) in case of a failure due to corruption,accidental deletion or whatsoever reason.In order to do so, you need to have the information like Last backup date-time, location of the backup … Continue reading How to check SQL Server Database Backup History for a server