always remember

Nothing is foolproof to a sufficiently talented fool... Make something
idiot proof, and the world will simply make a bigger idiot.

How To Setup Binary Replication Between 2 PostgreSQL 9.4 Hosts (Hot-Standby)

Utilising a master/slave (hot-standby) setup to provide a resilience layer at database level can be easy. The following assumes you have 2 PgSQL hosts at 10.10.50.1 and 10.10.50.2, both running Ubuntu 14.04 LTS and PostgreSQL 9.4 (9.4.5).

1. On the master 10.10.50.1, edit the following in postgresql.conf:

listen_addresses = '*'
wal_level = hot_standby
max_wal_senders = 3

listen_addresses can also be scoped down to single or multiple server bound IP addresses, for added security/best practice

Read On… ->

dave / April 7, 2016 / Guide, PostgreSQL

dave / April 6, 2016 / Code, Nagios Monitoring

Bash Application – Simpler Exim Queue Management

Ever get stuck trying to remember the exim/exiqgrep/xargs commands at that one critical moment when you need to stop 800,000 spam mail getting delivered to Hotmail accounts? Me too.. So I made this to help. My other monitoring & alert scripts should have told you by now that you have a spam outbreak, so you’ll know which sending host its coming from. Fire this application up on that host to quickly and effectively manage the items in the mail queue.

Read On… ->

dave / March 13, 2016 / Code, Linux Bash

Monitor PostFix Outbound Mail Queue + Email

Here we’ve got a very small, but effective script that alerts when a PostFix queue grows beyond a predefined limit. In my environment, PostFix is being used by an outbound relay. This script can work in tandem with my other mail queue monitoring script (Exim Mail Queue Monitor).

Read On… ->

dave / February 20, 2016 / Code, Linux Bash

Monitor Exim Mail Queue on Sending Hosts + Email Alert

A small bash script designed to run automatically and periodically (CRON) on sending hosts, i.e. shared web servers primarily. This monitors the size of the overall Exim mail queue (both inbound and outbound) and alerts via email when the queue grows beyond a pre-defined limit. Email provides information on top sending domains, or top recipient domains if inbound.

Read On… ->

dave / January 28, 2016 / Code, Linux Bash

dave / January 12, 2016 / Code, Nagios Monitoring