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
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?
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?
In the process of learning a new database technology, test out various features and to follow a tutorial, what you require is a sample database. Like other DBMS, there are a number of sample databases available for PostgreSQL as well. PostgreSQL has a number of sample database listed on their official site. You can go … Continue reading Restoring a Sample Database into PostgreSQL
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
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
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?
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
Thanks for joining me! Good company in a journey makes the way seem shorter. — Izaak Walton