Blog

PostGIS 2.3.3 is Now Available with BigSQL!

The good folks on the PostGIS development team recently the released of PostGIS 2.3.3: As befits a patch release, the focus is on bugs and breakages. Best served with PostgreSQL 9.6.3+ and pgRouting 2.4.1. See the full list of changes here. And now... the new release is available in the BigSQL distribution! If you haven't [...]

By | July 24th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , , , |1 Comment

Setting Up LDAP with Active Directory in PostgreSQL

In the example below, we are setting up LDAP with Active Directory (AD), one of the more popular server implementations, using the BigSQL PostgreSQL 96 distribution. Available for Windows and Linux. Download BigSQL Distribution Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell -NoProfile -ExecutionPolicy unrestricted -Command "iex ((new-object net.webclient).DownloadString('http://s3.amazonaws.com/pgcentral/install.ps1'))" Find the bigsql directory and install [...]

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

GDAL New Release 2.2 – BigSQL Makes it Easy to Install

The GDAL community just announced the release of GDAL 2.2... and BigSQL just made it easier to implement! Install it Now We support Diegos and Yodas with 2 ways to install: Option 1: Install with the pgDevOps GUI For GIS analysts (scientists, statisticians, analysts, etc) who find themselves as the de facto DBA (among other [...]

By | June 19th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , , , , |0 Comments

The Easy Way to Setup PostgreSQL 10 Logical Replication

One of the most exciting enhancements that comes with the new PostgreSQL 10 release, is Logical Replication. The functionality, although not yet as extensive as pgLogical which it is based on, provides a powerful replication option when you want control over table backups at a finite level - allowing all kinds of ETL goodness like: [...]

By | June 7th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , |11 Comments

Connecting to Remote Spatial Data Sources with ogr_fdw

Shout out goes to Regina Obe and Paul Ramsey for their work and documentation on ogr_fdw. The ogr_fdw project can be found here: https://github.com/pramsey/pgsql-ogr-fdw. ogr+fdw = ogr_fdw In an earlier post, I showed you how to use the ogr2ogr (or as my geogeek friends like to call it "ogre to ogre") command line tool to [...]

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

Installing pgDevOps

Install in 6 easy steps Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy steps. Already have BigSQL pgc installed? Jump to step #3. Read this short introduction to BigSQL's package and update manager (pgc). Install pgc via command line to a sandbox: MAC / Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell [...]

DevOps: Can’t we just all get along?

pgDevOps will help your developers and operations teams work collaboratively, efficiently, and openly. To understand the value added when you include pgDevOps in your PostgreSQL tool-chain, keep reading. tldr; Go straight to the tutorial to start using pgDevOps today! Why DevOps: A brief explainer First a little background to better understand why BigSQL built pgDevops. [...]

By | May 15th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , |2 Comments

Autonomous transactions using pg_background

Transactions are an important feature in any database and PostgreSQL has them. We want to be "ACID Compliant" and ensure that all data is read and written in a consistent state. All changes in the transaction either commit or rollback together. You never change just one table, without also changing all the other related tables [...]