This is one of a series of posts where I document software configurations for personal reference. This post documents the configurations for PostgreSQL.
~/.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.