Schwab password policies and two factor authentication: a comedy of errors

Like probably millions of people I have a Schwab brokerage account, and that account holds a good portion of my savings for retirement. I care very much about protecting my savings, and one would expect that Schwab would care a great deal about protecting a reputation for protecting me. This is why, during a recent… Continue reading Schwab password policies and two factor authentication: a comedy of errors

Modifying pg_backup to include a latest directory

I wanted to use this script to back up my database, but I needed a directory that would always have the latest version in it. I added/modified the following lines in the script: LATEST_BACKUP_DIR=$BACKUP_DIR”latest/” rm $LATEST_BACKUP_DIR”$DATABASE”.sql.gz cp $FINAL_BACKUP_DIR”$DATABASE”.sql.gz.in_progress $LATEST_BACKUP_DIR”$DATABASE”.sql.gz mv $FINAL_BACKUP_DIR”$DATABASE”.sql.gz.in_progress $FINAL_BACKUP_DIR”$DATABASE”.sql.gz Here’s the new script pg_backup.sh: #!/bin/bash ########################### ####### LOAD CONFIG ####### ########################### while… Continue reading Modifying pg_backup to include a latest directory

How to set up a Linode environment for the Pyramid Framework 1.5, Python 3, PostgreSQL 9.1 on Debian 7.5

I’m in the process of working on a new startup, and I finally decided to break down and do things right this time, which means leaving PHP and my custom written framework in the past. I’m not really a system administrator, so I figured when I set up my Linode there would be a guide out there to go by. To my surprise, even the Linode hosted config repository didn’t have what I needed or it was out of date. So, I just decided to do it all myself and learn it from scratch.

PostGIS Basics – Part 2 – Hello World

SELECT AddGeometryColumn(‘public’, ‘table’,’column’, 4269, ‘POINT’, 2) This will add a new column to the table and add an entry to the metadata table (the 4269 specifies my reference system, more on that below). It will also add a column to “table” and several constraint checks on the new column. Next, you’ll need to know about… Continue reading PostGIS Basics – Part 2 – Hello World