Blog

:PostgreSQL Tutorials

Learn about the credentials required to authenticate into our recently deployed Postgres Cluster from the Ansible Tower Template Job from Postgres DevOps Engineer Doug Ortiz.

Looking for an introduction to the new auto-create subpartitions feature in EDB Postgres Advanced Server 14? Software Engineer Beena Emerson is here to guide you on your way to understanding this time-saving new feature.

A caveat: Peter Eisentraut (formerly of 2nd Quadrant, now an EDB company) and myself are both now EDB employees.   On August 13th, 2020 Peter Eisentraut blogged on the topic of spinning up multiple instances of pgBouncer listening on the s ...

This article provides instructions for installing PostgreSQL as the backend database for WordPress instead of the default MySQL. Introduction What is PG4WP? How to install WordPress with PostgreSQL on Centos7

Abstract This article provides step-by-step instructions for using the EDB Postgres Backup and Recovery Tool (BART) to save PostgreSQL backups to Amazon AWS S3. Step 1: Install BART on master and standby servers Step 2: Install and configure ...

This article outlines the steps for creating and configuring EDB Postgres on VMware vSphere using Terraform with deployment scripts available on GitHub.

PostgreSQL Replication is when data is copied from one database server to another. The source database server is usually called the Master server, whereas the database server receiving the copied data is called the Replica server.

<p>This article looks at the processes involved in master-replica failover in PostgreSQL and the options and commands that are available for configuring it.</p>

<p>This article discusses the open source tool repmgr (Replication Manager) and how to set up and configure it for automatic failover in PostgreSQL.</p>

<p>This post discusses logical replication in PostgreSQL. It reviews the differences between physical or binary replication and logical or transactional replication.</p>

<p>With PostgreSQL v12,&nbsp; “recovery.conf” is no longer valid. Even if someone were to create a recovery.conf file manually and keep it under the data directory, the server is not going to start and will throw the following error</p>

<p>I recently had a few customers ask me about using a query for monitoring SMR XDB lag, so they can keep tabs on replication progress and set up notifications.</p>

<p>nterpriseDB Failover Manager (EFM) is a great tool to automate failover/switchover if you use Postgres' streaming replication feature. Not only do you get High Availability (HA), you can do so with just a few simple commands to make it all happen very quickly.</p>