Instant PostgreSQL Backup and Restore How-to

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "We can use the createdb utility to create an empty database for our backup experimentation."

A block of code is set as follows:

for f in $(find /db/pg_tblspc); do
    d=$(readlink -f $f)
    n=$(basename $f)
    tar -C $d . -c | pigz -p 8 > /backup/$n.tar.gz
done

Any command-line input or output is written as follows:

$> export PGUSER=postgres
$> createdb sample
$> pgbench -i -s 50 sample

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the ...