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