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...
Self-Provisioning of User Accounts in PostgreSQL via Unprivileged Anonymous Access
Note from Severalnines: This blog is being published posthumously as Berend Tober passed away on July 16, 2018. We honor his contributions to the PostgreSQL community and wish peace for our friend and guest writer....
More of My Favorite PostgreSQL Queries – and Why They Also Matter
In a previous blog post My Favorite PostgreSQL Queries and Why They Matter, I visited interesting queries meaningful to me as I learn, develop, and grow into a SQL developer role. One of those, in...
New Backup Management and Security Features for MySQL & PostgreSQL: ClusterControl Release 1.6.2
We are excited to announce the 1.6.2 release of ClusterControl - the all-inclusive database management system that lets you easily automate and manage highly available open source databases in any environment: on-premise or in the...
Custom Trigger Based Upgrades for PostgreSQL
1st RULE: You do not upgrade PostgreSQL with trigger-based replication 2nd RULE: You DO NOT upgrade PostgreSQL with trigger-based replication 3rd RULE: If you upgrade PostgreSQL with trigger-based replication, prepare to suffer. And prepare well....
PostgreSQL Log Analysis With pgBadger
Sometimes logs are the last things checked when things are going wrong, but they are usually the first things screaming for help when something happens. Manually looking through the logs for problems helps, but why...
Integrating Tools to Manage PostgreSQL in Production
Managing a PostgreSQL installation involves inspection and control over a wide range of aspects in the software/infrastructure stack on which PostgreSQL runs. This must cover: Application tuning regarding database usage/transactions/connections Database code (queries, functions) Database...
MariaDB Backup & PostgreSQL in the Cloud – ClusterControl Release 1.6.1
We are excited to announce the 1.6.1 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases in any environment: on-premise or...
PostgreSQL Streaming Replication – a Deep Dive
Knowledge of replication is a must for anybody managing databases. It is a topic that you probably have seen over and over but never gets old. In this blog, we will review a little bit...
The Best Alert and Notification Tools for PostgreSQL
As part of their enterprise monitoring system, organizations rely on alerts and notifications as their first line of defense to achieving high availability and consequently lowering outage costs. Alerts and notifications are sometimes used interchangeably,...
Tips for Managing Your Database Configurations
In the past five posts of the blog series, we covered deployment of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health,...