Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
21 blog posts in 1 category

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

ClusterControl 1.5 - PostgreSQL Load Balancing & ProxySQL Enhancements

This post provides an overview of the new load balancing features found in ClusterControl 1.5 including enhanced ProxySQL support and Load Balancing support for 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.

Video: Interview with OptimaData's Martijn Wallet on the Benefits of PostgreSQL

We sat down with Severalnines partner OptimaData and their founder Martijn Wallet to discuss PostgreSQL and how & why they utilize it with their customers.

Posted in:

An Expert's Introduction to PostgreSQL, Database Management and ClusterControl

Basic concepts of PostgreSQL and how ClusterControl fills the gap. Besides ClusterControl a range of related tools for PostgreSQL usage are highlighted.

Pages