Hi all
I have a hot standby replication setup.
But for no apparent reason, it stops the recovery. Here is a part of the
log:
2011-02-21 11:07:03 BRT LOG: restored log file
"00000001000000090000001B" from archive
2011-02-21 11:07:33 BRT LOG: restored log file
"00000001000000090000001C" from archive
2011-02-21 11:08:03 BRT LOG: restored log file
"00000001000000090000001D" from archive
2011-02-21 11:11:34 BRT LOG: could not open file
"pg_xlog/00000001000000090000001E" (log file 9, segment 30): No such
file or directory
2011-02-21 11:11:34 BRT LOG: redo done at 9/1DA2E410
2011-02-21 11:11:34 BRT LOG: last completed transaction was at log time
2011-02-21 09:12:00.61-03
2011-02-21 11:12:04 BRT LOG: restored log file
"00000001000000090000001D" from archive
2011-02-21 11:15:04 BRT LOG: selected new timeline ID: 2
2011-02-21 11:18:04 BRT LOG: archive recovery complete
Formato de parĭetro incorreto - "chive".
2011-02-21 11:18:04 BRT WARNING: recovery_end_command "del
D:/Archive/026/failover.trigger": return code 1
2011-02-21 11:18:05 BRT LOG: database system is ready to accept connections
And here is my recovery.conf file:
restore_command = '"C:/program files
(x86)/postgresql/9.0/bin/pg_standby.exe" -s 30 -t
D:/Archive/026/failover.trigger D:/archive/026 %f %p %r
2>>D:/archive/026/pg_standby.log'
trigger_file = 'D:/Archive/026/failover.trigger'
recovery_end_command = 'del D:/Archive/026/failover.trigger'
What can be making it stop the recovery. Any ideas?
Thanks
Norberto Dellê
