set_user: Understanding Logfile Output

As we discussed in our initial blog post on set_user, the Sarbanes–Oxley Act, passed in 2002, requires publicly owned companies to audit a user's (esp. superuser's) access and interactions with data. Companies storing financial or human subject data are particularly susceptible to hacking. What you need is x-ray vision Your audit trail should always include [...]

set_user: Understanding the set_user_u Function

In our last blog post, set_user: Installation and Set-Up, we introduced you to the set_user component, installed the extension in a database, created a new user, and granted it set_user function execution privileges. If you recall, the set_user documentation states the main goal is to: grant the EXECUTE privilege to the set_user() and/or set_user_u() function [...]

By | September 18th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , , |0 Comments

set_user: Installation and Set-Up

If you haven't installed the BigSQL Postgres Distribution, you can start here to use an installer or here if you want to create a sandbox via command line. Next, via command line, navigate to the BigSQL or PostgreSQL directory where pgc is located run the update command (to get the latest releases), install PostgreSQL and [...]

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

BigSQL Now Includes the set_user Extension

We are excited to announce our newest addition to the available components with BigSQL PostgreSQL Windows, Linux, and OSX distributions: set_user 1.4.0! And... to kick it off, we will be writing multiple posts about this essential security extension. But first (for the uninitiated) some context... Since the Sarbanes–Oxley Act passed in 2002 as a response [...]

By | September 15th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , |0 Comments

BigSQL Announces Support of pg_hint_plan in Linux

You say Optimizer, I say Planner... But, oh, if we call the whole thing off Then we must part And, oh, if we ever part, then that might break my heart... Are you an Oracle DBA making the transition to PostgreSQL? Are you longing for the good old days when you could override decisions made [...]

By | August 29th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , |5 Comments

BigSQL + PostGIS: Reprojecting Your Spatial Data with ST_Transform

With our latest release of PostGIS (release 2.3.3), projection datum shift files have been included across all the platforms. You will find them located in: bigsql/pg96/share/postgresql/contrib/postgis-2.3/proj Why do you care? Well, this means you can easily reproject your PostGIS data using the ST_Transform command. > ST_Transform — Return a new geometry with its coordinates transformed [...]

By | July 31st, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , , |0 Comments

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 [...]

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

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