pgmoneta

Appearance

Feature extra ​

This tutorial will show you how to configure the extra feature to retrieve extra files and directories (recursively) from the PostgreSQL server instance.

Preface ​

This tutorial assumes that you have an installation of PostgreSQL 13+, pgmoneta_ext, and pgmoneta.

See Install pgmoneta_ext and Install pgmoneta for more detail.

Configuration ​

In order to use exta, simply add

ini
extra = /tmp/myfile, /tmp/mydir, /tmp/mydirs
extra = /tmp/myfile, /tmp/mydir, /tmp/mydirs

to the corresponding server section of pgmoneta.conf. pgmoneta will retrieve extra files and directories (recursively) from the PostgreSQL server instance when performing a backup.

You can use

sh
pgmoneta-cli -c pgmoneta.conf backup primary
pgmoneta-cli -c pgmoneta.conf backup primary

to trigger the client to get extra files from the server side.

All the files will be stored in the /extra directory under the backup directory. For our configuration, they will be stored in the /tmp/primary/<timestamp>/extra directory.

Info ​

You can use

sh
pgmoneta-cli -c pgmoneta.conf info primary newest
pgmoneta-cli -c pgmoneta.conf info primary newest

to show all copied extra files, something like this (only showing successfully copied files):

console
Extra                : myfile, ...
Extra                : myfile, ...