WAL management with OmniPITR
Transaction log files, that is WAL logs, play a significant role in different situations be it for backups, point in time recovery, replication, or even crash recovery.
Here we are going to utilize the OmniPITR tool to effectively manage WAL log files for archival and recovery purpose.
Getting ready
The prerequisites are that OmniPITR needs to be installed on all the participating servers. Here we are assuming three servers, one is the primary server, the next one is the slave server, and the other one is the backup server.
We also assume the following configuration on these servers.
On the master server, we should have or create the following directories that should be writeable by the postgres user:
/home/postgres/omnipitr: Location of the data files stored by omnipitr/home/postgres/omnipitr/log: Location of the omnipitr log/home/postgres/omnipitr/state: Location of the omnipitr state files/var/tmp/omnipitr: Location of temporary files created by omniPITR
On...
