AkbarAhmed.com

Engineering Leadership

Introduction RazorSQL is a GUI tool for working with Postgresql. Install RazorSQL First, create the razorsql directory. mkdir ~/Downloads/razorsql Download RazorSQL into the ~/Downloads/navicat directory. Open a web browser to http://www.razorsql.com/download_linux.html. Click Download next to Linux (64-bit). After the download completes, open a command prompt and enter the following commands. I have assumed that you …

Continue reading

Introduction The default installation of Postgresql does not allow TCP/IP connections, which also means JDBC connections wont’ work. Enable TCP/IP Connections cd /etc/postgresql/9.1/main Let’s make a backup of the original config file. sudo cp postgresql.conf postgresql.conf.org sudo vi postgresql.conf Find the line that contains #listen_addresses = ‘localhost’ and change it to: listen_addresses = ‘localhost’ If …

Continue reading

Introduction Installing Pig is drop dead simple. Installation sudo apt-get install pig Check the Pig version. pig –version Setup the Environment We’re going to set the environment variables system-wide for Pig programming. sudo vi /etc/environment Paste the following environment variables into the environment file. HADOOP_MAPRED_HOME=”/usr/lib/hadoop-mapreduce” PIG_CONF_DIR=”/etc/pig/conf” source /etc/environment That’s it. You can now start to …

Continue reading