Continuous recovery stopping
От | Norberto Delle |
---|---|
Тема | Continuous recovery stopping |
Дата | |
Msg-id | 4D627922.9020102@gmail.com обсуждение исходный текст |
Список | pgsql-general |
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ê
В списке pgsql-general по дате отправления: