Monthly Archives: October 2017

//October

PostgreSQL 10.0 – Features New and Updated

Overview: PostgreSQL 10 contains many new features that will allow users to both scale out and scale up their PostgreSQL infrastructure. To upgrade to PostgreSQL 10 from any lower releases, a pg_dumpall dump and restore or pg_upgrade is necessary. In this article, we will go over some new features that have been added and also [...]

By | October 18th, 2017|Categories: Jobin PostgreSQL|Tags: , , , |0 Comments

Setting up PL/R with Postgres on Windows

1. Introduction Setting up extra extensions / features on proprietary platform like Windows is a challenge because we don't have a default build environment. Setting up a complete build environment for installing a language extension is bigger challenge. Thanks to vibrant community, many of the heavy lifting is already done. I would like to Acknowledge [...]

By | October 16th, 2017|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL|3 Comments

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