Forewords
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.