Tag Archives: postgresql

My Move to Improving Enterprises, Part 1

This blog article has turned into a ridiculously long posting that I’m splitting into 2, possibly 3 parts. The series pretty much recaps what I did at the College of Architecture and what I’m doing at Improving Enterprises. Enjoy! For … Continue reading

Posted in *nix, Personal, Software Development, Systems Administration | Tagged , , , , , , , , , , , | 1 Comment

pg_service.conf Syntax

I am setting up monitoring for my PostgreSQL database server, and ran across a cool way to get around specifying the username/password via the command-line every time the checks are run: pg_service.conf. Unfortunately, there is very little documentation on the … Continue reading

Posted in *nix, Systems Administration | Tagged , | Leave a comment

PostgreSQL Group & User Role Inheritance

As I’m trying to finish up one of my consulting projects (and enhance other active projects), I decided to take a nice long hard look a PostgreSQL permissions – the correct way of doing it. PostgreSQL applies the commonly accepted … Continue reading

Posted in SQL | Tagged , | Leave a comment