Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Deploy PostgreSQL to a Docker Container Using ClusterControl

Deploying a single PostgreSQL instance on Docker is fairly easy, but deploying a replication cluster requires a bit more work. In this blog, we’ll see how to deploy PostgreSQL on Docker and how we can make it easier to configure a primary-standby replication setup with ClusterControl.

How to Use pgBackRest to Backup PostgreSQL and TimescaleDB

Managing backup environments can be complex, and, in case of failure, it’s important to reduce downtime and loss of data as much as possible. Full, differential and incremental backups are good options, they also help reduce the disk space usage. There are other important features like backup verification, uploading to remote systems or cloud, and compression, to complete our backup strategy. In this blog, we’ll see how we can use pgBackRest for backing up PostgreSQL and TimescaleDB and how we can manage all of these features from the same system.

Configuring PostgreSQL for Business Continuity

Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even during the disasters, otherwise, could end-up being an expensive deal.

How to Replicate PostgreSQL Data to Remote Sites

In a busy database environment with larger size databases, the need for real-time data replication is a common occurrence. Applications often need the production data to be replicated in real-time to remote sites for analytics and other critical business operations needs. This blog provides an overview of several options you can use to replicate your PostgreSQL data to a remote site.

The Current State of Open Source Backup Management for PostgreSQL

This blog takes a deep-dive into the most popular open source backup programs available for PostgreSQL, what their current state is, and how they compare to one another.

Migrating from DB2 to PostgreSQL - What You Should Know

This blog provides a high level overview of what you should know if considering a move from IBM’s DB2 to PostgreSQL including a comparison of commands and an examination of the incompatibilities of the databases.

How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability

Automating all your business processes with Odoo puts stringent requirements on the availability of the platform. What do you do if a server fails? In this blog post, we’ll show you how to cluster Odoo to achieve better availability and scalability on multiple servers. The softwares used are Odoo 12, HAProxy 1.8.8, Keepalived 1.3.9, PostgreSQL 11 and OCFS2 (Oracle Cluster File System).

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.

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.