Setting Up PostgreSQL

Abstract

Guidance on setting up a fresh PostgreSQL installation.

Introduction

This is one of a series of posts where I document software configurations for personal reference. This post documents the configurations for PostgreSQL.

Configuring psql

Edit ~/.psqlrc and append the file with the following lines:

\set AUTOCOMMIT off
\set ON_ERROR_ROLLBACK interactive
\set PROMPT1 '%/%x%# '

Here’s another post that provides more insights on this topic.

Configuring the server

See my previous post for instructions on continuous archiving and point-in-time recovery.