#!/bin/bash
export PGPASSWORD="airtime"
/usr/bin/pg_dump -C -h ORIGINAL_PG_HOST -x --inserts -T cc_listener_count -T cc_timestamp -U airtime airtime_db | /usr/bin/psql -h localhost -U airtime airtime
Note this requires the pg_hba to be configured on both database hosts. Seems to be running smoothly so far. Failover currently is to unplug the soundcard and plug into the other host where udev rules restart the airtime playout engine so no reboot is required.
It looks like you're new here. If you want to get involved, click one of these buttons!