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...
Best Practices for Database Backups
Backups - one of the most important things to take care of while managing databases. It is said there are two types of people - those who backup their data and those who will backup...
Migrating from MSSQL to PostgreSQL – What You Should Know
As you may know, Microsoft SQL Server is very popular RDBMS with highly restrictive licencing and high cost of ownership if the database is of significant size, or is used by a significant number 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 Minimize RPO for Your PostgreSQL Databases Using Point in Time Recovery
In a disaster recovery plan, your Recovery Point Objective (RPO) is a key recovery parameter that dictates how much data you can afford to lose. RPO is listed in time, from seconds to days. Effectively,...
Dynamic Monitoring of PostgreSQL Instances Using pg_top
Monitoring PostgreSQL can, at times, be like trying to wrangle cattle in a thunderstorm. Applications connect and issue queries so quickly, it’s hard to see what’s going on or even get a good overview of...
A New Way to Personalize Your PostgreSQL Monitoring with Prometheus
Monitoring is one of the fundamental tasks in any system. It can help us to detect problems and take action, or simply to know the current state of our systems. Using visual displays can make...