Postgres

Postgres queries and reporting.

Query of the century

5 February, 2015 1 min read 38 words
One Postgres transaction that swaps a table for a freshly loaded copy: CREATE TABLE LIKE, COPY, two renames and a drop.

Bacula daily (or weekly) email report for postgres DB

21 January, 2014 1 min read 5 words
A shell report that pulls Bacula job results out of the Postgres catalogue and emails a daily or weekly summary.