Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

PostgreSQL High Availability with Master-Slave & Master-Master Architectures

Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing).

For HA PostgreSQL configurations we can have several architectures, but the basic ones would be master-slave and master-master architectures.

Top GUI Tools for PostgreSQL

Using a GUI is not a must, but it can be useful in some cases. In this blog, we'll see some advantages and warnings about the use of these tools, as well as do a short review of some of the most commons GUI tools for PostgreSQL.

How to Manage Your PostgreSQL Databases from the ClusterControl CLI

What if you could deploy a 3-node streaming replication setup in one command? Or orchestrate a master failover with reslaving of nodes in one command? Welcome to ClusterControl’s command line interface to manage your PostgreSQL setups. This blog post shows you how to manage your PostgreSQL streaming replication cluster using s9s, the ClusterControl CLI.

Webinar Replay: How to Automate & Manage PostgreSQL with ClusterControl

Watch the replay of our webinar on how to automate and manage PostgreSQL with ClusterControl. Sebastian Insausti, Support Engineer at Severalnines, will introduce us to the world of PostgreSQL ops automation: from the ‘old ways’ to the modern way of managing PostgreSQL; including a look at ClusterControl’s integrated approach to deployment, monitoring, performance management, scaling, upgrades and backup, delivered as an integrated suite that plugs into your favourite tools.

An Overview of JSON Capabilities Within PostgreSQL

This blog provides an overview of the JSON capabilities within PostgreSQL which were released in version 9.2.

One Security System for Application, Connection Pooling and PostgreSQL - The Case for LDAP

This blog describes how you can use LDAP for both authentication and connection pooling with your PostgreSQL database.

How to Optimize Performance of ClusterControl and Its Components

This blog post explains a number of ways to improve performance of ClusterControl and its components.

Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1

A few days ago was the release of a new version of ClusterControl, the 1.7.1, with several new features, including for PostgreSQL. In this blog, we will see how to deploy PostgreSQL 11 version using ClusterControl. We’ll also check out the new backup verification feature that you can use to automatically test your backups.

Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

An Overview of Just-in-Time Compilation (JIT) for PostgreSQL

Just-in-Time (JIT) compilation is the process of turning some form of interpreted program evaluation into a native program, and doing so at runtime. This blog shows hows to use this with PostgreSQL, which has built-in support to perform JIT compilation using LLVM when PostgreSQL is built with --with-llvm.