Hello all,
I am having a little trouble with a hot standby configuration on Windows, and I was hoping I could find an answer here.
Everything works fine (both machines run just fine, and the hot standby works like a charm), except for one problem. The pg_archivecleanup refuses to run; it seems like I am writing the wrong command, since the %r does not get replaced.
The log is full of sets of lines like these :
pg_archivecleanup: must specify restartfilename
Try "pg_archivecleanup --help" for more information.
2011-07-09 11:09:28 EEST WARNING: archive_cleanup_command "pg_archivecleanup.exe "C:\ArchiveDir\" %r >c:\cleanup.log": return code 2
I thought that the command line would be built properly (I mean the %r would be replaced by the caller), but for some reason it is not happening.
I'm out of ideas to try... what am I doing wrong ?
Thanks in advance for any help.
Stefan.