
Blog
:PostgreSQL TutorialsResources, tips, and tricks on PostgreSQL high availability, monitoring, tuning, security, and migration
Search
How to find your authentication credentials from an Ansible Tower Template Job integrated with edb-ansible Scripts
Doug Ortiz—7/14/2021Learn 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 14
Beena Emerson—7/12/2021Looking 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_REUSEPORT
Phil Hankinson—4/26/2021A 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 PostgreSQL
Mohsin Ejaz—9/22/2020This 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 S3
Sunil Narain—8/12/2020Abstract 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 Terraform
Kanchan Mohitey—5/14/2020This 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 Tutorial
Abbas Butt—4/30/2020PostgreSQL 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 does PostgreSQL master-replica failover work?
Amit Sharma—3/24/2020<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>
How to implement repmgr for PostgreSQL automatic failover
Ranjeet 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>
Logical Replication in PostgreSQL Explained
Kuntal Ghosh—12/4/2019<p>This post discusses logical replication in PostgreSQL. It reviews the differences between physical or binary replication and logical or transactional replication.</p>
How to manage Replication and Failover in Postgres Version 12 without recovery.conf file
Tushar 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 lag
Richard 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 Switchover
Richard 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>
- «
- ‹
- 1
- ›
- »
Popular Posts
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 moreDemo 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