Resources, tips, and tricks on PostgreSQL high availability, monitoring, tuning, security, and migration
How to find your authentication credentials from an Ansible Tower Template Job integrated with edb-ansible ScriptsDoug Ortiz—7/14/2021
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.
How to Create Subpartition Template in EDB Postgres Advanced Server 14Beena Emerson—7/12/2021
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.
pgBouncer Setup, Extended Architecture, Use-cases and leveraging SO_REUSEPORTPhil Hankinson—4/26/2021
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 ...
How to deploy WordPress with highly available PostgreSQLMohsin Ejaz—9/22/2020
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
How to setup EDB Postgres Backup and Recovery Tool to take PostgreSQL backup on Amazon AWS S3Sunil Narain—8/12/2020
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 ...
How to deploy PostgreSQL along with Monitoring and high availability tools on VMware vSphere using TerraformKanchan Mohitey—5/14/2020
This article outlines the steps for creating and configuring EDB Postgres on VMware vSphere using Terraform with deployment scripts available on GitHub.
PostgreSQL Replication and Automatic Failover TutorialAbbas Butt—4/30/2020
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.
How to implement repmgr for PostgreSQL automatic failoverRanjeet Dhumal—3/23/2020
<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>
How to manage Replication and Failover in Postgres Version 12 without recovery.conf fileTushar Ahuja—11/6/2019
<p>With PostgreSQL v12, “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>
How to determine Single Master XDB replication lagRichard Yen—10/27/2017
<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>
What Happens When I Press Enter? -- EDB failover manager SwitchoverRichard Yen—8/18/2017
<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>
BigAnimal: Fully managed PostgreSQL in the cloud
BigAnimal features Oracle compatibility, built-in high availability, and 24/7 support from our team of PostgreSQL experts.Learn more
Demo of Oracle SQL compatibility in BigAnimal
BigAnimal lets you run Oracle SQL queries in the cloud via EDB Postgres Advanced Server. Watch the video, or load up psql and follow along.Learn more