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 ...
Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
