Tag: nagios

Feed: Planet PostgreSQL. check_pgbackrest is designed to monitor pgBackRest backups, relying on the status information given by the info command. The biggest change in this new release is that the tool will now only support pgBackRest 2.32 and above in order to only use its internal commands. This remove Perl dependencies no-longer needed to reach repository hosts or S3 compatible object stores. This also brings Azure compatible object stores support. The repo-* arguments have then been deprecated. pgBackRest 2.32 has been released this week and brings official support for the repository commands: repo-ls and repo-get. Let’s find out in this ... Read More

Feed: Planet PostgreSQL. One of my colleagues at EDB spent some time working on a new extension for PostgreSQL and EDB Postgres Advanced Server as part of a proof of concept that I asked him to look into. I'm pleased to say that we've decided to make that work Open Source, releasing it under the PostgreSQL licence.The system_stats extension offers a number of stored procedures that are useful when monitoring Postgres. They expose various system metrics to the database server, allowing you to extend your database monitoring to include information about CPU, memory, disk and network usage without having to add a ... Read More

Feed: Planet PostgreSQL. SummaryOne of the most frustrating parts of an Oracle to PostgreSQL migration is the fact that both products use the same terminology, but with vastly different meanings. It is very easy to get caught up in a terminology misunderstanding and spend quite some time arguing across one another, only to find out that there wasn’t any disagreement at all. This rather strange argument becomes even more confusing as other add-on technologies are involved. Seeking to reproduce the same functionality across the two systems by adding components can make the transition easier, but strangely makes the dialogue harder ... Read More

Feed: Planet MySQL; Author: FromDual; FromDual has the pleasure to announce the release of the new version 1.2.0 of its popular Database Performance Monitor for MySQL fpmmm.The FromDual Performance Monitor for MySQL (fpmmm) enables DBAs and System Administrators to monitor and understand what is going on inside their MySQL database instances and on the machines where the databases reside. More detailed information you can find in the fpmmm Installation Guide. Download The new FromDual Performance Monitor for MySQL (fpmmm) can be downloaded from here or you can use our FromDual repositories. How to install and use fpmmm is documented in ... Read More

Feed: Planet PostgreSQL. When I started this, I thought it was be straight forward and take only a few hours at most. It turned into multiple hours over two days. This is part two of a two-part post. The first part dealt with changing a database column from time to timestamp. In this post: PostgreSQL 12.2 Nagios 3.5 FreeBSD 12.1 The queries The two queries I want to run are: SELECT count(*) FROM cache_clearing_dates WHERE date_added > now() - interval '1 hour'; SELECT count(*) FROM cache_clearing_ports WHERE date_added > now() - interval '1 hour'; The script Combining those two into ... Read More

Feed: Planet PostgreSQL. The plan for today was not decided until after I got out of bed. I sat down with coffee and looked through the list of tasks. I found one which appealed: monitor the cache_clearing_ports & cache_clearing_dates tables This is part one of a two-part story. The first part deals with fixing a database table before doing the planned work in part two, a Nagios check. In this post: PostgreSQL 12.2 Nagios 3.5 FreeBSD 12.1 FreshPorts stores a lot of data in the database, but caches pages on disk. Specific events clear that cache, and the two tables ... Read More

Feed: Planet PostgreSQL. check_pgbackrest is designed to monitor pgBackRest backups, relying on the status information given by the info command. The changes in this new release are: missing archives output: the complete list is now only shown in --debug mode; new --list-archives argument to print the list of all the archived WAL segments found. Let’s use the 1.7 release and see the basic output: $ /usr/lib64/nagios/plugins/check_pgbackrest --version check_pgbackrest version 1.7, Perl 5.16.3 $ /usr/lib64/nagios/plugins/check_pgbackrest --stanza=my_stanza --service=archives --repo-path=/var/lib/pgbackrest/archive WAL_ARCHIVES OK - 24 WAL archived, latest archived since 2m27s | latest_archive_age=147s num_archives=24 $ /usr/lib64/nagios/plugins/check_pgbackrest --stanza=my_stanza --service=archives --repo-path=/var/lib/pgbackrest/archive --output=human Service : WAL_ARCHIVES Returns ... Read More

Feed: Planet PostgreSQL. check_pgbackrest is designed to monitor pgBackRest backups, relying on the status information given by the info command. The main features are: check WAL archives consistency; check the retention policy; check its own version; multiple output format: human, json and nagios. The RPM file made it’s way to the PGDG Yum repository! Special thanks to Devrim for that! It can also be found in the Dalibo Labs Yum repository. Install the Official PostgreSQL yum repo package or the Dalibo Labs yum repo package yum install nagios-plugins-pgbackrest Remark: epel-release also needs to be installed first. The service fails when ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; What I learned from and appreciated in these talksFirst of all, I really loved the emphasis on how important it is to talk to each other, be open, and feeling empathy for the other person’s (and other team's) job challenges. It’s hard to build and maintain infrastructure and software, and you're not the only one finding it difficult. Few people are trying to make your job harder, and it's important to remember this, especially when things go wrong.I also paid attention to Ben raising the issue of how difficult it really is to ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Companies that want to introduce new features to customers quickly are either already practicing continuous delivery or working towards it — or they should be ... Read More