BIG NEWS from BigSQL: Introducing pgDevOps!

To help our colleagues at OpenSCG provide better service to our clients, BigSQL developed pgDevOps - a one stop shop to provision, develop, and monitor PostgreSQL databases. And now... we are making pgDevOps available to the PostgreSQL community! How Does pgDevOps Help? Install and Provision: Package Manager: One-click installs of PostgreSQL [...]

By | March 30th, 2017|Categories: BigSQL, Holly PostgreSQL, OpenSource|Tags: , , , , , , |2 Comments

Why Migrate?

“Why migrate to Postgres?” is a question that we used to hear a lot in the past. There used to be a number of different reasons to migrate including, take advantage of new technology, a change of staff skills, vendor consolidation caused friction and of course, cost. Nowadays, the main reason we hear for migrating [...]

By | March 8th, 2017|Categories: Migration, OpenSCG, OpenSource, PostgreSQL, Uncategorized|Tags: , , , |0 Comments

Successful database Migrations : Are they really possible?

We talk to a lot of clients who want to perform database migrations but just about all of them are skeptical that the project will be a success. There are a number of reasons for this, including: Fear Lack of time to take on project Belief that their usage isn’t easy convertible to a new [...]

By | March 2nd, 2017|Categories: OpenSCG, OpenSource, PostgreSQL, thoughts, Uncategorized|Tags: , , , , |0 Comments

Don’t move your Oracle database to the cloud

Why move your Oracle database to the cloud? It just doesn't make sense. You are moving to the cloud for flexibility, for cost savings, for ease of changing your infrastructure. Does doubling your Oracle license fee for AWS or Azure usage sound like Oracle wants to let you have flexibility or cost savings?? (Hint: NO!!) [...]

By | February 7th, 2017|Categories: OpenSource|Tags: , , , , |0 Comments

Relocatable PG RPMs

Relocatable PostgreSQL RPMs - You asked and we delivered! In our years of dealing with PostgreSQL users, one of the main gripes they have with PostgreSQL is not a missing feature or capability but rather it is the fact that the provided rpms are non relocatable rpms. The reasons for wanting relocatable rpms are many [...]

By | October 19th, 2016|Categories: BigSQL, Dave PostgreSQL, OpenSource|Tags: , , , |0 Comments

Why Open Source over Open Source Based?

The Postgres landscape has become very competitive in recent years as the database project has matured and grown exponentially in popularity. Since more and more users are deploying Postgres to support a wide variety of applications, there is a need for experts to help make sure those deployments are successful. This has led to the [...]

By | October 18th, 2016|Categories: OpenSource, PostgreSQL|Tags: , , , , |1 Comment

BigSQL Hadoop + Postgres now Available as a VM

With the continued success of the BigSQL developer's bundle, we are proud to announce the availability of a new VM image with BigSQL preinstalled.  Primarily created to provide our Windows friends access to the technology bundle, the Image is based on CentOS 6.4 Desktop including many tools to begin exploring today.  Join our free Beta [...]

By | November 20th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG, OpenSource|Tags: |Comments Off on BigSQL Hadoop + Postgres now Available as a VM

Installing and Running BigSQL, the Hadoop and Postgres Bundle

This tutorial will show you how to install and run BigSQL. You can download the bundle from and get started using Hadoop, Hive, Hbase, and PostgreSQL in less than ten minutes. The video below goes over how to: Complete the prerequisites (the commands used can be found here) Start the bundle Open the psql, hive, [...]

By | October 16th, 2013|Categories: BigSQL, OpenSCG, OpenSource|Comments Off on Installing and Running BigSQL, the Hadoop and Postgres Bundle

Hadoop Tutorials Hive HBase Flume Scoop Thrift and More

Over the last several months the team at OpenSCG has created a number of Hadoop Tutorials covering key  projects in the Hadoop ecosystem including Hive, HBase, Flume, Scoop and Thrift.  These Tutorials are designed to quickly highlight the usage of Hadoop with working examples that can be quickly worked through and modified!  To help you find [...]

By | September 5th, 2013|Categories: Hadoop, OpenSCG, OpenSource|Comments Off on Hadoop Tutorials Hive HBase Flume Scoop Thrift and More

Hadoop Sqoop Tutorial HDFS Hive & Postgres

The Hadoop Sqoop Tutorial is the third in the series providing easy to follow examples of using a Hadoop cluster in conjunction with Postgres.  This tutorial will build on the Hadoop Hive Tutorial which should be considered a pre requisite if you want to run the examples provided. In this tutorial, we will create a Postgres table from public domain [...]

By | July 10th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on Hadoop Sqoop Tutorial HDFS Hive & Postgres