Finding Postgres pg_hba.conf File

The pg_hba.conf file is the PostgreSQL Client Authentication Configuration File, aka the Host Based Authentication File. Depending on your distro/system, it may be installed in different locations. One easy way to find it would be to issue the following command from the psql command line: psql > SHOW hba_file; This command will show you the […]

Appian 17.2 on Docker

This walk-through explains how to set up Appian 17.2 on Docker. It was going to happen sooner or later 🙂 Approach I deliberated on two approaches: Lightweight containers, and have the host OS to manage the Appian components, and Heavy containers (Appian components sit within Docker image), but rely less on host OS I chose […]

Installing Appian 17.2 on Centos 7

As part of a recent project, I was provided the opportunity to evaluate Appian (a Business Process Management Suite) and how it can fit the requirements. As part of the exploratory phase, I had to understand Appian’s architecture and install an evaluation instance. This post will describe the installation steps I took to get Appian […]

Getting psql Utility on Windows CLI

I recently had to connect to a Postgres database on the network to perform some simple administrative tasks. However, the Windows machine I had did not have Postgres installed. As I only needed the “psql” utility to connect and query the database, and not the entire database engine, I was reluctant to install Postgres on […]