Simple Postgresql Cron Backup

Here is a very simple method to backup your postgresql DB using a cron job and the pg_dump command. The main problem people encounter when trying to automate the pg_dump command is the password input. Now you could easily create a local user with no password, but why would you want to do that.

Read the rest of this entry »

Installing MySQL gem for Ruby 1.9.x

As of this writing, the MYSQL gem cannot be installed by simply doing a GEM INSTALL with ruby 1.9.1. In order to install the gem, follow these easy steps.

First download the mysql gem from rubyforge, and unzip it:

sudo wget http://rubyforge.org/frs/download.php/51087/mysql-ruby-2.8.1.tar.gz

 sudo tar -xzvf mysql-ruby-2.8.1.tar.gz

 cd mysql-ruby-2.8.1

Read the rest of this entry »