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....
Utilizing Encryption to Strengthen PostgreSQL Database Security
Please Note: Portions of the blog contain references and examples from "ANNOUNCING AVAILABILITY OF POSTGRESQL INSTANCE LEVEL ENCRYPTION" by CyberTec, a company which provides support, consulting and training for PostgreSQL. Organizations deal with different types of...
How to Create a Single Endpoint for Your PostgreSQL Replication Setup using HAProxy
Managing traffic to the database can get harder and harder as it increases in amount and the database is actually distributed across multiple servers. PostgreSQL clients usually talk to a single endpoint. When a primary...
How to Deploy PostgreSQL for High Availability
Introduction Nowadays, high availability is a requirement for many systems, no matter what technology you’re using. This is especially important for databases, as they store data that critical applications and systems rely on. The most...
How to Monitor PostgreSQL using Nagios
Introduction Regardless of database technology, it is necessary to have a monitoring setup,both to detect problems and take action, or simply to know the current state of our systems. For this purpose there are several...