/Holly Orr

About Holly Orr

Holly Orr has spent the past 20+ years working in IT departments and geospatial labs on the east and west coasts. Her journey has taken her from jobs as desktop and web developer, database administrator, data steward, analyst, help desk, and GIS educator. Holly has an MS in Information and Knowledge Strategy from Columbia University and a BA in Political Science with a minor in Geography from Temple University. She has taught graduate level GIS courses at NYU and Hunter College. In a past life, Holly toured in a rock band playing lead electric guitar. Today, when she isn’t attending her son’s break dancing recitals, she plays for fun in her rock band, Giant Gowanus.

set_user: Understanding Advanced Control Features – Whitelist

For this last post in our set_user series, let's look at how we can limit who is allowed to escalate to superuser at a super granular level. Whitelist By default, the whitelist parameter is set to allow all (*) users with set_user permissions to escalate to superuser. But what if you want to limit these [...]

By | October 11th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , |0 Comments

set_user: Understanding Advanced Control Features – Block Settings

Remember way back in the set_user Installation and Set-Up post when we edited postgresql.conf to add set_user to the shared_preload_libraries? Well, there are some additional parameters that may be optionally added to the config file and set to control their respective commands. Block settings First, let's look at the settings that limit users who have [...]

By | October 2nd, 2017|Categories: Holly PostgreSQL|0 Comments

set_user: Ensuring Superuser Auditing

Before continuing our series on the set_user extension, let's review what we have gone over so far: set_user: Installation and Set-Up set_user: Understanding the set_user_u Function set_user: Understanding Logfile Output If you haven't completed the exercises in the previous articles you might want to backtrack. Otherwise, onward! By default, the postgres user is created as [...]

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

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

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: , , , , , , , |4 Comments