PostGIS – How to create a Spatial Database with PGC Command Line

We are excited to announce that BigSQL distributions of PostGIS now come bundled with several popular community spatial extensions: postgis fuzzystrmatch postgis_tiger_geocoder postgis_topology ogr_fdw address_standardizer address_standardizer_data_us This is the only community distribution to offer PostGIS with these extensions across ALL platforms (Mac, Linux, and Windows)! So, for all you GeoGeeks using Linux / Mac - [...]

By | February 10th, 2017|Categories: Holly PostGIS|Tags: , , |1 Comment

pg_repack in Postgres by BigSQL

Many DBAs agree that one of the most useful extension in their arsenal is pg_repack. Pg_repack addresses a serious shortcoming in Postgres: doing VACUUM FULL online. Due to the way Postgres handles the MVCC, tables and indexes become bloated. Dead tuples are addressed by AUTOVACUUM and space will be marked free. In many situations a [...]

By | January 9th, 2017|Categories: Jobin PostgreSQL|Tags: , , , |0 Comments

Integrating Cassandra, Spark, PostgreSQL and Hadoop as a Hybrid Data Platform – Part 3

In a previous blog post we talked about the technical details behind the new CassandraFDW that enables PostgreSQL to connect to a Cassandra cluster. This provides PostgreSQL users the ability to easily read and write data to a very popular open source multi-master database that can support writes in multiple data centers. This means if [...]

Two great things that taste great together: PostGIS and PostgreSQL

In my past life as a geospatial DBA, I had to navigate users and managers who belonged to different database teams (PostgreSQL, MySQL, SQL Server, Oracle, etc). When I was lucky enough to work in a shop that supported open source solutions, I was often asked by members of team MySQL, “Why should we use PostgreSQL [...]

By | October 17th, 2016|Categories: Holly PostGIS|Tags: , , |1 Comment

Holy Easy PostgreSQL deployment

Holy Easy PostgreSQL deployment! In case you missed it, the BigSQL team released an awesome package manager for installing and configuring PostgreSQL and many related, useful components. The package manager can be found here: Playfully named pgc, for ‘pretty good command line’, pgc is a utility similar to yum or apt-get that allows you [...]

By | October 14th, 2016|Categories: BigSQL, Dave PostgreSQL, OpenSCG|Tags: , , , |0 Comments

Why are you still paying for your GIS when you can get it for free?

If you haven’t switched to open source solutions (FREE!), then you have probably fallen for some common misconceptions/myths: MYTH: Open source tools are buggy. Does software have bugs? Of course. It was made by humans! But open source has the benefit of a strong community that can crowdsource fixes because the code base is not [...]

By | October 4th, 2016|Categories: Holly PostGIS|Tags: , , , , , |0 Comments

Tutorial on running Crystal Reports with BigSQL in Eclipse

1. Pre Requsites to run this tutorial: a) BigSQL Tutorial The BigSQL tutorial is required to be followed till the first three steps from the following link Step 1 : Creating example.customer_history in HIVE and loading values. Step 2 : Creating example.customer_history as foreign table in Postgres Step 3 : Verifying example.customer_history b) Eclipse [...]

By | October 4th, 2013|Categories: BigSQL, Hadoop|Tags: , , , , , , |Comments Off on Tutorial on running Crystal Reports with BigSQL in Eclipse

NYC PGDAY BigSQL Presentation

At NYC PGDAY 2013 Denis Lussier presented BigSQL = Postgres + Hadoop. Denis' BigSQL presentation focused on leveraging both PostgreSQL and Hadoop to create a data platform to meet today's expanding enterprise data needs. The presentation does a great job of detailing the Open Source components included in OpenSCG's developer bundles with an explanation of each component's value [...]

By | March 26th, 2013|Categories: Big Data, BigSQL, conference|Tags: , , |Comments Off on NYC PGDAY BigSQL Presentation