Vagrant On-Database Analytics Sandbox
VODAbox combines a Scientific Linux virtual machine with PostgreSQL, PL/Python, PL/R, and MADlib to allow for extremely easy experimentation with on-database analytics.
- Download and install VirtualBox
- Download and install Vagrant
- Create a new folder on your computer to hold shared documents for VODAbox
cd
to this directory and runvagrant init
- Run
vagrant box add <VODAbox> http://lyte.id.au/vagrant/sl6-64-lyte.box
- Pull codes from this git repository into the new folder
- Run
vagrant up
- Run
vagrant ssh
- Use something like PuTTY to log into your virtual machine with the ssh information given by the above
- Within PuTTY
cd /vagrant
login as "su" (password = vagrant) and run./finish_install.sh
then log-out of root - Start Postgres with the command
sudo service postgresql-9.2 start
- Run codes in examples using the command
psql -d maddb -f
filename.sql
A presentation on VODAbox given at the Champaign Urbana Database User Group on April 3rd, 2014.