pgAdmin3 LTS Now Supports PostgreSQL 8.4 – 10

We are pleased to announce pgAdmin3 LTS is now available on OSX and Windows for PostgreSQL 10! As v1.0 of pgAdmin4 was released in September of 2016, the pgAdmin Development Team decided to no longer support pgAdmin III with any more fixes. We believe that pgAdmin3 usage should fade out over time and have forked [...]

By | June 22nd, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , |2 Comments

Install PostgreSQL 10 Today

Hey, have you heard? PostgreSQL 10 Beta is road ready! Kick the tires and take the cool new features and improvements out for a spin. Highlights include: Declarative Partitioning Logical Replication SCRAM Authentication See the full list of features here. Take the easy route Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy [...]

By | May 19th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , |2 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

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

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


BigSQL. From data to information, from information to insight. A state-of-the-art Big Data Warehouse solution that is fast, secure and continuously available. BigSQL will scale from your desktop to the cloud. Run real time OLAP directly from the worlds most secure RDBMS. Get started with BigSQL right now. You can immediately put BigSQL to work [...]

PostgreSQL Clustering with Postgres HA

PostgreSQL Clustering made easy with PostgresHA. Authored jointly with Scott Mead, Sr. Architect OpenSCG and Architect of PostgresHA. PostgresHA is Highly Available (HA) PostgreSQL. High Availability High availability is not new. Financial trading systems and the telephone network were federally mandated to provide highly availability. People didn’t do HA because it was a fun project, [...]

By | April 17th, 2013|Categories: High Availability, OpenSCG, OpenSource, PostgreSQL|Tags: , , , , , , , , |Comments Off on PostgreSQL Clustering with Postgres HA