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...
Webinar Replay: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl
Thanks to everyone who participated in this week’s webinar on ‘Backup Management with ClusterControl’. The replay is now available to watch online as well as the slide deck. If you feel frustrated by traditional, labour-intensive...
Care To Know Clauses: All About SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT
SQL is a language of databases and PostgreSQL is our chosen one. Oftentimes, storing data is but one facet of the process. Typically, in any data-centered endeavor, you will: view and read data, take action...
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...