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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general