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.