Monthly Archives: May 2013

PostgreSQL FDW to Hadoop Hive Tutorial

PostgreSQL Foreign Data Wrapper to Hadoop Hive Tutorial 2 In our last tutorial, Hadoop Hive Tutorial – Zero to Results in 15 Minutes, we installed Postgres and Hadoop and ran some simple queries against a sample dataset directly against Hive tables.  In this tutorial we will create a FDW (Foreign Data Wrapper) in Postgres and access the [...]

By | May 30th, 2013|Categories: Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on PostgreSQL FDW to Hadoop Hive Tutorial

Ganglia monitoring of large (and small) clusters

Lately, I've been spending more time back in the performance testing world.  The problem is that the testing we're doing is taking days and in some cases, weeks to run.  No matter how diligent you are, you're not going to be staring at your CPU / memory graphs the whole time.  The question is, what [...]

By | May 24th, 2013|Categories: Big Data|Tags: , , |Comments Off on Ganglia monitoring of large (and small) clusters

Hadoop Hive Tutorial – Zero to Results in 15 Minutes

This Tutorial will walk through using Hadoop's Hive to access data stored in HDFS.  This is the first tutorial (more to follow) and covers installing Hadoop as part of BigSQL and running some simple queries. The Platform:  Linux (RHEL, CentOS or Ubuntu) or Mac OSX.  The Hadoop and Postgres Install was from www.BigSQL.org.  Takes about [...]

By | May 23rd, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG, OpenSource|Tags: , |Comments Off on Hadoop Hive Tutorial – Zero to Results in 15 Minutes

Security Hardening PostgreSQL

Take a look at our doc on Hardening your PostgreSQL deployment.  We use these strategies internally and with our customers and it's a great way to make sure you're secure from top to bottom. http://openscg.com/2013/04/security-hardening-postgresql/

By | May 17th, 2013|Categories: OpenSCG, OpenSource, PostgreSQL|Comments Off on Security Hardening PostgreSQL

SQL vs NoSQL Fireworks not Included

SQL vs NoSQL Fireworks SQL has a lot going for it and that's not going to change for quite a while. Let's face it, real big investments are being made every day on products like Oracle, SQL Server, PostgreSQL, Teradata, Firebird... you get the idea. Wikipedia provides a great comparison of relational database [...]

By | May 16th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG, OpenSource|Comments Off on SQL vs NoSQL Fireworks not Included

PgLife Averages Thirty Active Users

A week after the release of PgLife, the site is averaging thirty active users. (I define an active user as an IP address that has viewed the site for at least five minutes during the past hour.) I consider that a success. Since the release of PgLif...

By | May 13th, 2013|Categories: news|Comments Off on PgLife Averages Thirty Active Users

OwnCloud: An Open Source DropBox

I'm very impressed with what this open source community has done. Take a look at OwnCloud.org for yourself. We are running an internal pilot of this at OpenSCG for the last few months. AFAIK it's been very stable for us and it's pretty feature rich. --Luss

By | May 11th, 2013|Categories: OpenSource|Comments Off on OwnCloud: An Open Source DropBox

How to compile PostgreSQL 9 on Ubuntu

This has been tested to work with PG 9.1, 9.2, 9.3 & 9.4dev. It is also known to work on Ubuntu 10, 11, 12 & 13. I also recently got a chance to verify that it works on the ARM flavor of Ubuntu. Pre-Requisites: [code] $ sudo apt-get install build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev [...]

By | May 11th, 2013|Categories: PostgreSQL|Comments Off on How to compile PostgreSQL 9 on Ubuntu