Обсуждение: Hot standby on Windows
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.
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.
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.
On 14/07/2011 10:05 PM, stefanu wrote: > 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 don't use hot standby on Windows, but since there's been no other response to this I'll try to have a look at it this weekend. -- Craig Ringer POST Newspapers 276 Onslow Rd, Shenton Park Ph: 08 9381 3088 Fax: 08 9388 2258 ABN: 50 008 917 717 http://www.postnewspapers.com.au/