From: | chinnaobi <chinnaobi(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | archive_cleanup_command recovery.conf Standby server error |
Date: | 2012-02-28 06:36:08 |
Message-ID: | 1330410968208-5520966.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Durumdara | 2012-02-28 09:26:09 | Correct way for locking a row for long time without blocking another transactions (=nowait)? |
Previous Message | Jameison Martin | 2012-02-28 06:21:24 | Re: synchronous replication: blocking commit on the master |