Re: archive_cleanup_command recovery.conf Standby server error

From: chinnaobi <chinnaobi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: archive_cleanup_command recovery.conf Standby server error
Date: 2012-03-02 08:28:48
Message-ID: 1330676928670-5530337.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Reichstadt 2012-03-02 08:59:49 Quoted strings on CLI
Previous Message Adam Cornett 2012-03-01 22:30:14 Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?