Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

Webinar: How to Automate & Manage PostgreSQL with ClusterControl

Join us on January 22nd for a webinar on how to automate and manage PostgreSQL. Sebastian Insausti, Support Engineer at Severalnines, will introduce us to the world of PostgreSQL ops automation. We’ll also have 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 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.

PostgreSQL Replication for Disaster Recovery

This blog explains how to utilize streaming replication and point in time recovery to achieve high availability using failover.

PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends

PostgreSQL has seen real growth in the past few years, getting closer and closer to MySQL, which continues to be the world’s most popular open source database. In this blog we explore what’s been happening with PostgreSQL in 2018 and some predictions for the future.

Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server

This blog discusses logical replication in PostgreSQL: its use cases, general information on the status of this technology, and a special use case in particular on how to setup a subscriber (replica) node of the primary server in order to function as the database server for the testing environment, and the challenges met.

How to Take Advantage of the New Partitioning Features in PostgreSQL 11

With the recent release of PostgreSQL 11 there are a lot of new amazing partitioning features. The details of these new partitioning features will be covered in this blog with a few code examples.

An Overview of the New Stored Procedures in PostgreSQL 11

The recent release of PostgreSQL 11 included the introduction of stored functions that allow users to use embedded transactions within a procedure. In this blog we deep-dive into this new PostgreSQL feature.

What's New in PostgreSQL 11

This blog provides an overview of the new features and functions that can be found in PostgreSQL 11 including stored functions, partitioning, and much more!

Ten Ways to Expand the Functionality of PostgreSQL

There are different extensions to improve or adapt your PostgreSQL to specific needs. In this blog, we'll see some of the most popular open source extensions in PostgreSQL and how it can be used to expand its capability.

Pages