Re: archive_cleanup_command recovery.conf Standby server error - Mailing list pgsql-general

From chinnaobi
Subject Re: archive_cleanup_command recovery.conf Standby server error
Date
Msg-id 1330676928670-5530337.post@n5.nabble.com
Whole thread Raw
In response to Re: archive_cleanup_command recovery.conf Standby server error  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: archive_cleanup_command recovery.conf Standby server error  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
1. I tried with below command in recovery.conf with the exe pointing to the
location where it is present.
Result:

2012-02-29 19:56:49 MYT WARNING:  archive_cleanup_command ""D:\Program Files
(x86)\PostgreSQL\9.1\data\pg_archivecleanup.exe" -d
\\NOBE-HGG-SRV-04\DB_Stream_Share\ %r": return code 1
'D:\Program' is not recognized as an internal or external command,

operable program or batch file.

It is clearly the path is not recognized by the exe.

2. I tried manually running in the DOS command

D:\Program Files (x86)\PostgreSQL\9.1\data\pg_archivecleanup.exe -d
"\\NOBE-HGG-SRV-04\DB_Stream_Share\" %r

Error: Pg_archivecleanup: must specify restartfilename

3. pg_archivecleanup.exe -d "\\NOBE-HGG-SRV-04\DB_Stream_Share\" %r
error: Invalid filename input

4. Tried pg_archivecleanup.exe -d "d:\DB_Stream_Share\" %r
Error: archive location doesn't exist tried with \\ as well same
5. Tried  pg_archivecleanup.exe -d
"d:\DB_Stream_Share\000000001000000000002D" %r
Error: must specify restartfilename

archive_Cleanup_command:the command it runs is the DOS command ??
The tool is not able to recognize the path

Adrian,
 clearly the share or the folder WAL files have permissions to everyone.
Please let me know if you got something on this ..


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/archive-cleanup-command-recovery-conf-Standby-server-error-tp5520966p5530337.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Adam Cornett
Date:
Subject: Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?
Next
From: Alexander Reichstadt
Date:
Subject: Quoted strings on CLI