Sysadmin & Cloud
Server administration, Linux, self-hosting, and cloud infrastructure guides from decades of running my own systems. 30 posts
Setting up Automatic Updates for Ubuntu
How-To
How to enable unattended upgrades on Ubuntu so security patches install themselves, with the apt config files and options explained.
Astaro Security Gateway - Setting up a Public Web Server with Web Application Firewall
How-To
How to publish an internal web server through the Astaro Security Gateway (Sophos UTM) Web Application Firewall instead of a plain DNAT.
Create a Startup / Boot Script under Ubuntu
How-To
How to write an LSB-compliant init script on Ubuntu, with the required header, start and stop actions, and install steps to run at boot.
Configure SSH2 Access for Updating WordPress
How-To
How to make WordPress updates run over SSH2 instead of FTP on Ubuntu, with a dedicated user, SSH key pair, and the php libssh2 extension.
Secure your WordPress Installation
How-To
How to harden a WordPress install with tested backup plugins like BackupBuddy, strong admin passwords, and basic security steps.
B&N NOOK Color - Your $250 Android Tablet
How-To
How to turn the $250 Barnes & Noble NOOK Color into a full Android tablet running Gingerbread or Honeycomb, with real hardware specs.
April Fools!  Your blog backup is incomplete.
Sysadmin & Cloud
VaultPress backed up my WordPress blog 743 times, then failed me at recovery. Why automated backups mean nothing until you test a restore.
What I Learned about Time Machine backups from timedog
Apple & macOS
Time Machine was backing up 920MB I didn't need. How the timedog Perl script shows what changed and which files to exclude from backups.
Goodbye Quicken Essentials 2010 for Mac, Hello iBank 4
Apple & macOS
Why I dumped Quicken Essentials 2010 for iBank 4 after Intuit locked in my data, and the parsing work it took to free my transactions.
15 min read
MySQL Database Replication over an SSH Tunnel
How-To
How to run MySQL master-slave replication through an SSH tunnel, covering key setup, my.cnf settings, and the replication user grants.
macOS Hints and Tips
How-To
Hidden macOS keyboard shortcuts and settings you won't find in System Preferences, from startup keys to Finder and Dock tricks.
Battle of the Clouds - Rackspace Cloud vs. Amazon EC2
Sysadmin & Cloud
Rackspace Cloud vs. Amazon EC2 in 2010, compared on instance sizes, hourly pricing, and features, with a winner picked in each category.
14 min read
Moving from SquareSpace to Wordpress
How-To
Why I moved robpickering.com from SquareSpace to WordPress in 2010, and how to migrate posts, dates, authors, and comments intact.
Create a Full Backup Image of your Amazon EC2 Instance
How-To
How to create a full backup AMI of an Amazon EC2 instance, plus a 2016 update on the AWS console's one-click Create Image option.