Azure CLI and Postgres

We discussed about how to setup a PostgreSQL on Azure cloud DaaS (Database as a Service), as a novice user. When it comes to real world use of Postgres, the first thing that comes to mind for a DBA is how to access PostgreSQL logs. So it is time for exploring Azure command line (CLI) [...]

By | January 24th, 2018|Categories: Jobin PostgreSQL|Tags: , |0 Comments

As a novice user at Azure Database for PostgreSQL

Owing to growing popularity of PostgreSQL, more and more cloud providers have started offering their Database as a Service (DaaS) platform around PostgreSQL. What user gets is a fully managed, ready-to-use Database service. Microsoft Azure cloud announced their PostgreSQL as a service in May 2017. Disclaimer: This post is a purely personal view based on [...]

By | January 4th, 2018|Categories: Jobin PostgreSQL|Tags: , , , , |0 Comments

Migrating partitioned tables to PostgreSQL 10’s Native Partitioning

In this article, we will focus on upgrade from 9.4 (and above) versions to PostgreSQL 10, leveraging the full features of native partitioning. Test Environment: OS: CentOS 7 PostgreSQL version: 9.6.3 and 10.0 pg_partman version: 3.1.0 Migrating from 9.x version (partitioned table with inheritance) to pg10 (native partitioning) Consider a database with several tables some [...]

By | November 9th, 2017|Categories: Jobin PostgreSQL, Migration|Tags: , , , , |2 Comments

Upgrading to Postgres 10 : Postgres by BigSQL

Many are experimenting with Postgres 10 and testing their applications against it. Postgres binaries from BigSQL are inherently relocatable / portable . This makes it especially easy if you want try upgrading or just want to check the upgradability of your application. Here are the steps for an easy upgrade from Postgres 9.6 to Postgres [...]

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

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

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: 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