Re: archive_cleanup_command recovery.conf Standby server error

On Friday, March 02, 2012 12:28:48 am chinnaobi wrote:
> 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,

Would seem it is having problem with space in path name and is trying to run
D:\Program as a program and failing. Try quoting that part of the path i.e
"Program Files (x86)"

>
> 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

Again please read the information in the link below:

http://www.postgresql.org/docs/9.1/interactive/pgarchivecleanup.html

Running from the command line is different from running from recovery.conf

The Error is telling you what to do and the link will give you the information
on how to do it.

>
> 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

Just the same problem repeated. As stated before %r is not recognized when the
program is run from the command line.

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

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com