I've given PITRTools a try, but I have been unsuccessful in utilising it. I've configured both ini files, everything owned by user postgres, and upon running "./cmd_archiver -C cmd_archiver.ini" I get:
NOTICE: check_config_func()
NOTICE: Performing standard archive
NOTICE: archive_func()
NOTICE: send_queue_func()
NOTICE: list_queue_func()
NOTICE: generate_slave_list_func()
NOTICE: Your slaves are: ['192.168.1.17']
Traceback (most recent call last):
File "../pitr_tools/cmd_archiver", line 343, in <module>
archive_func()
File "../pitr_tools/cmd_archiver", line 254, in archive_func
queue = send_queue_func()
File "../pitr_tools/cmd_archiver", line 219, in send_queue_func
for host in list_queue_func():
File "../pitr_tools/cmd_archiver", line 202, in list_queue_func
list_archives = os.listdir(queuedir)
OSError: [Errno 2] No such file or directory: '/var/lib/postgresql/archive/
192.168.1.17'
The only time that IP address appears in the INI file is on the slaves line, so I'm not sure why it's trying to find a directory called that.