PostgreSQL Replication for Disaster Recovery
With Disaster Recovery, we aim to set up systems to handle anything that could go wrong with our database. What happens if the database crashes? What if a developer accidently truncates a table? What if...
PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends
A strong community coupled with an increasingly stable and feature-rich platform are making PostgreSQL a strong contender for replacing the “big boys” of enterprise data. We here at Severalnines have also seen this trend and...
Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL
If you’re looking at minimizing downtime and meet your SLAs through an automated or semi-automated approach, then this webinar replay is for you: A detailed overview of what failover processes may look like in MySQL,...
Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server
In this blog entry we’ll talk about 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...
How to Take Advantage of the New Partitioning Features in PostgreSQL 11
What is Partitioning? Partitioning splits large tables into smaller pieces, which helps with increasing query performance, making maintenance tasks easier, improving the efficiency of data archival, and faster database backups. You can read more...
How to Upgrade PostgreSQL10 to PostgreSQL11 With Zero Downtime
Historically, the hardest task when working with PostgreSQL has been dealing with the upgrades. The most intuitive upgrade way you can think of is to generate a replica in a new version and perform a...
An Overview of the New Stored Procedures in PostgreSQL 11
As you may know in all the versions up to PostgreSQL 10, it was not possible to create a procedure in PostgreSQL. In PostgreSQL 11, PROCEDURE was added as a new schema object which is...
What's New in PostgreSQL 11
PostgreSQL 11 was released on October 10th, 2018, and on schedule, marking the 23rd anniversary of the increasingly popular open source database. While a complete list of changes is available in the usual Release Notes,...
Ten Ways to Expand the Functionality of PostgreSQL
As you may know, you can extend PostgreSQL functionality by using PostgreSQL extensions. You can use different extensions to make PostgreSQL like an enterprise version and address specific needs. In this blog, we'll see some...
Cloud Backup Options for PostgreSQL
This blog was updated on 11/27/18 and 11/29/18 to make changes as recommended by our awesome commentors! As with any other component of a business, databases are extremely important its inner workings. Whether it’s the core...
Scaling Connections in PostgreSQL Using Connection Pooling
Opening a database connection is an expensive operation, and connection pooling is used to keep database connections open so they can be reused. This avoids having to repeatedly open network sessions, authenticate and check authorisation....
Five Cool Things I Learned at the PostgreSQL Conference Europe 2018
I spent a week in the magnificent city of Lisbon attending the annual European PostgeSQL Conference. This marked the 10th anniversary since the first European PostgreSQL conference and my sixth time attending. First Impressions The...