On 02/29/2012 04:40 AM, chinnaobi wrote:
> Hi Adrian,
>
> The pg_archivecleanup.exe is already installed with postgresql 9.1, it is
> under bin folder. I tried manually to run the command pg_archivecleanup.exe
> \\\\10.1.18.16\\DB_Stream_Share\\ %r -- it didnt recognize the path
When using pg_archivecleanup from the command line %r is not used.
See below for more information:
http://www.postgresql.org/docs/9.1/interactive/pgarchivecleanup.html
> pg_archivecleanup.exe \\10.1.18.16\DB_Stream_Share\ %r --it didnt recognize
> the path
What was the exact error message?
>
> I gave this path directly in the recovery.conf yet the same, there is
> something missing ..
>
> What is that ? please help me around this ..
I don't use Postgres on Windows so I am going to be of limited use here.
If it me though I would investigate/do the following:
1) Does the user you are running pg_archivecleanup as have rights to the
WAL archive directory?
2) Copy the archived WAL files to another less convoluted path and see
if it is a path problem.
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/archive-cleanup-command-recovery-conf-Standby-server-error-tp5520966p5524854.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
--
Adrian Klaver
adrian.klaver@gmail.com