Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
70 blog posts in 13 categories

Tracking High Availability for PostgreSQL with Heartbeat

This blog details how you can use the program Heartbeat to deliver high availability for PostgreSQL.

How to Deploy PostgreSQL for High Availability

In this blog, we will review some important concepts of High Availability, possible database HA architectures and useful components when implementing PostgreSQL HA. Then we will see how to use ClusterControl to deploy an entire high availability stack for PostgreSQL.

An Overview of Volume Level Replication for PostgreSQL Using DRBD

Volume level replication is a generic approach that not only applies to PostgreSQL, but also all relational databases. In this blog, we’ll show you how to use DRBD,  a distributed replicated storage system for Linux, to replicate your database for high availability.

How to Monitor PostgreSQL using Nagios

Regardless of database technology, it is necessary to have a monitoring setup, to detect problems so we can take action, or simply to know the current state of our systems. In this blog, we’ll take a look at one of the most widely used monitoring tool: Nagios.

Creating New Modules using PostgreSQL Create Extension

The PostgreSQL Create Extension allows you to extend the functionality of PostgreSQL to meet the needs of your specific application. This blog details how to use this functionality.

A Guide to Partitioning Data In PostgreSQL

For databases with extremely large tables, partitioning is a wonderful and crafty trick for database designers to improve database performance and make maintenance much easier.  This blog provides an overview of partitioning data for PostgreSQL.

Multitenancy Options for PostgreSQL

How do you get multiple databases to co-exist in Postgres? Do you place them in separate databases within the same cluster? Or is a harder separation approach better? Are there any implications on security or the ability to get a consolidated view of the data? As we will see in this blog, there are different approaches to consider.

Understanding System Columns in PostgreSQL

A system column is a a table with OIDs. OID is auto-incrementing integer value, unique within a PostgreSQL database (not just a table) that can be automatically assigned to each row of a table created WITH OIDS option.

Using Barman to Backup PostgreSQL - An Overview

Barman is a backup and disaster recovery solution for PostgreSQL databases that allow you to achieve high business continuity requirements.

PostgreSQL Streaming Replication vs Logical Replication

This blog provides an overview of streaming replication and logical replication for PostgreSQL and what you can use each for in your setup.