Re: PSQL 9.1 Streaming Replication Windows 2008 64 bit Servers - Mailing list pgsql-general

From chinnaobi
Subject Re: PSQL 9.1 Streaming Replication Windows 2008 64 bit Servers
Date
Msg-id 1330399322507-5520733.post@n5.nabble.com
Whole thread Raw
In response to Re: PSQL 9.1 Streaming Replication Windows 2008 64 bit Servers  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hi Adrian,

Thanks for the reply streaming is working after placing the recovery.conf in
standby data folder.

I add an extra configuration in the recovery.conf :

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

The 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


Thanks in advance

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PSQL-9-1-Streaming-Replication-Windows-2008-64-bit-Servers-tp5518918p5520733.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: "canceling autovacuum time"
Next
From: Andy Colson
Date:
Subject: Re: strategies for dealing with frequently updated tables