Category: PostgreSQL

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