Hot standby ​

This tutorial will show you how to configure a hot standby instance.

Preface ​

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

See Install pgmoneta for more detail.

Configuration ​

In order to use hot standby, simply add

hot_standby = /your/local/hot/standby/directory

hot_standby = /your/local/hot/standby/directory

to the corresponding server section of pgmoneta.conf. pgmoneta will create the directory if it doesn't exist, and keep the latest backup in the defined directory.

You can use

hot_standby_overrides = /your/local/hot/standby/overrides/

hot_standby_overrides = /your/local/hot/standby/overrides/

to override files in the hot_standby directory.