Search Postgresql Archives

archive_cleanup_command recovery.conf Standby server error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Streaming replication in the standby has successfully started (windows 2008
server) but, the configuration in the recovery.conf : 

archive_cleanup_command='pg_archivecleanup \\\\10.1.18.16\\DB_Stream_Share\\
%r'

standby server log file says error as below : 

2012-02-28 10:59:01 MYT FATAL:  the database system is starting up 
2012-02-28 10:59:01 MYT LOG:  database system was shut down in recovery at
2012-02-28 10:58:59 MYT 
2012-02-28 10:59:01 MYT LOG:  entering standby mode 
2012-02-28 10:59:01 MYT LOG:  restored log file "000000010000000000000027"
from archive 
2012-02-28 10:59:01 MYT LOG:  redo starts at 0/27000020 
2012-02-28 10:59:01 MYT LOG:  consistent recovery state reached at
0/28000000 
2012-02-28 10:59:01 MYT LOG:  database system is ready to accept read only
connections 
2012-02-28 10:59:01 MYT LOG:  unexpected pageaddr 0/20000000 in log file 0,
segment 40, offset 0 
2012-02-28 10:59:02 MYT LOG:  streaming replication successfully connected
to primary 
'pg_archivecleanup' is not recognized as an internal or external command, 

operable program or batch file. 

2012-02-28 11:04:01 MYT WARNING:  archive_cleanup_command "pg_archivecleanup
\\NOBE-HGG-SRV-04\DB_Stream_Share\ %r": return code 1 
'pg_archivecleanup' is not recognized as an internal or external command, 

operable program or batch file. 

2012-02-28 11:09:01 MYT WARNING:  archive_cleanup_command "pg_archivecleanup
\\NOBE-HGG-SRV-04\DB_Stream_Share\ %r": return code 1 
'pg_archivecleanup' is not recognized as an internal or external command, 

operable program or batch file. 

2012-02-28 11:14:01 MYT WARNING:  archive_cleanup_command "pg_archivecleanup
\\NOBE-HGG-SRV-04\DB_Stream_Share\ %r": return code 1 

What is the correct command there ???

Thanks in advance for any help..

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux