Computer Plumber
  • About
  • Services
  • Contact
  • Policies
  • 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 »

    Share
    1 comment backup, Databases, Linux, Postgresql, scripts, Ubuntu
  • 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 https://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 »

    Share
    No comments command line, Databases, gem, Linux, MYSQL, Rails, Ubuntu

Pages

  • About
  • Contact
  • Policies
  • Services

Categories

  • Amazon (13)
  • Databases (11)
  • Linux (48)
  • Mac (35)
  • Rails (13)
  • Virtual (8)
  • Web (33)
  • Windows (35)
  • follow me on Twitter

 

Computer Plumber | Computer Service Excellence