Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

PostgreSQL Load Balancing Using HAProxy & Keepalived

Promoting a new master server and failing over slaves sounds good, but your applications will need an easy way to keep track of the new master. That’s where HAProxy comes in. This blog post describes how to deploy HAProxy on top of your PostgreSQL replication setup.

Performing Replication Topology Changes for PostgreSQL

Database replication setups are rarely static. Servers can fail, the operating system or the database software might need to be upgraded. This means reshuffling server roles and moving replication links, while maintaining data consistency across all databases. This post explains how to perform these topology changes in PostgreSQL, while ensuring data consistency.

Become a PostgreSQL DBA: Point-in-Time Database Restoration

In this blog post,  we describe how to perform point-in-time recovery in PostgreSQL

Become a PostgreSQL DBA: Adding Additional Nodes To a Replication Setup

Master-slave replication setups can be very useful, as they provide multiple copies of the data for high availability or for scale out purposes. Master slave replication setups can be ver useful as they provide multiple copies of the data from a redundancy perspective., We will show you how to add nodes to an existing PostgreSQL replication setup using ClusterControl.

Become a PostgreSQL DBA: Best Community Tools for PostgreSQL

This blog features some of the most widely used PostgreSQL tools to help you get up-and-running.

Become a PostgreSQL DBA: PostgreSQL Server Configuration Parameters

In this blog, we focus on connection, logging and memory parameters important to PostgreSQL Server Configuration.

Become a PostgreSQL DBA: Understanding the Architecture

In this blog, we will discuss the PostgreSQL architecture and how the various components of PostgreSQL interact with each other.

Become a PostgreSQL DBA - Logical & Physical PostgreSQL Backups

Taking backups is one of the most important tasks of a DBA - it is crucial to the availability and integrity of the data. Part of our Become a PostgreSQL DBA series, this blog post covers some of the backup methods you can use with PostgreSQL.

Become a PostgreSQL DBA - How to Setup Streaming Replication for High Availability

In this post, we will show you how to set up master-slave replication with Postgres.

Become a PostgreSQL DBA: Provisioning and Deployment

This post is the first in the “Become a PostgreSQL DBA” blog series and will cover provisioning and deployment.