Compile PostgreSQL 9.3.4 from source under Ubuntu

The advantage of compiling PostgreSQL from source is that you can compile with certain flags/options which may be missing/disabled in stock-standard Ubuntu packages. Caveats and disclaimers I don't pretend to be an expert at Postgresql (Feel free to comment below).…

Cisco WCCP2 with Squid Proxy and SquidGuard

There are a number of good reasons for deploying proxies at work or at home Restricting web access for specific sites Reduce traffic volumes Monitoring and Managing bandwidth Optionally restrict when someone can surf the web Many more While searching the Internet for s…

How to back directories in Linux

* Open your favorite text editor and create a file under: /usr/local/bin/backup.sh Copy and paste the script into the backup.sh file # What to backup. backup_files="/var/www /etc /root /home/ubuntu" # Where to backup to. dest="/mnt/backup" # Create archive filename. ho…

How to build pgRouting from source on Ubuntu 13.10

pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality. To begin download and install the dependencies dev libraries apt-get install libcgal-dev libboost-thread-dev libboost-system-dev libboos…