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...
PostgreSQL Tuning: Key Things to Drive Performance
PostgreSQL and Performance Performance is one of the key requirements in software architecture design, and has been the focus of PostgreSQL developers since its beginnings, also shown in the following PostgreSQL Git sources commit: commit...
Architecture and Tuning of Memory in PostgreSQL Databases
Memory management in PostgreSQL is important for improving the performance of the database server. PostgreSQL configuration file (postgres.conf) manages the configuration of the database server. It uses default values of the parameters, but we can...
Tuning Input/Output (I/O) Operations for PostgreSQL
PostgreSQL is one of the most popular open-source databases in the world and has successful implementations across several mission-critical environments across various domains, using real-time high-end OLTP applications performing millions and billions of transactions per...
Backup PostgreSQL Using pg_dump and pg_dumpall
Businesses and services deliver value based on data. Availability, consistent state, and durability are top priorities for keeping customers and end-users satisfied. Lost or inaccessible data could possibly equate to lost customers. Database backups should...
A Performance Cheat Sheet for PostgreSQL
Performance is one of the most important and most complex tasks when managing a database. It can be affected by the configuration, the hardware or even the design of the system. By default, PostgreSQL is...
Managing MySQL, MongoDB & PostgreSQL with ChatOps from Slack
What is ChatOps? Nowadays, we make use of multiple communication channels to manage or receive information from our systems, such as email, chat and applications among others. If we could centralize this in one...
Deploying PostgreSQL on a Docker Container
Introduction Docker modernized the way we build and deploy the application. It allows us to create lightweight, portable, self sufficient containers that can run any application easily. This blog intended to explain how to use...