-
Migrate your TimescaleDB from timescale.com to self hosted
I’ve been using timescale.com for about a year, but it’s quite expensive for a hobbyist (their cheapest plan in the UK is about $50/month), so I thought i’d try and implement something cheaper. I know i won’t get the cool automatic DR failover or the sexy continuous backups – but it’s not really mission critical…
-
The Multiplier Effect: How The Aggregation of Marginal Delays Derails Projects
The Aggregation of Marginal Gains is an improvement model attributed to Dave Brailsford. When he took over as the head of British Cycling in 2002, the team was near the bottom of the rankings. Brailsford’s approach was to look at their processes in tiny detail, and improve each part by 1%, the logic being that…
-
FIX: The key(s) in the keyring /etc/apt/trusted.gpg.d/???.gpg are ignored as the file is not readable by user ‘_apt’ executing apt-key
When running apt-get update i was seeing these errors: I was getting this error after migrating keys from the old, legacy store to a the shiny new one. A quick inspection shows that the new keys have different permissions to the existing ones The fix is pretty simple. Pick one of the pre-existing GPG keys,…
-
FIX: Key is stored in legacy trusted.gpg keyring
While running apt-get update I was seeing errors: Although the warning is annoying, it doesn’t stop things updating. I understand the reasons why the legacy keyring is being removed. Migrate existing keys to the new keyring First, list the keys: In my case, i’ve got two – one for PostgreSQL and one for timescaledb. You…