Hi, I'm testing serveral days a replication-system with PostgreSQL, but I get allways the same error.
2009-10-25 15:44:45 CET FATAL: XX000: could not restore file "00000001.history" from archive: return code -1073741811 The restore_command is: restore_command = 'pg_standby.exe -d -s 5 -t C:\pgsql.trigger.5442 w:\wal-archive %f %p %r 2>>pg_log\pg_standby.log' The system is runnig on WinXP (during this test), the database-version is 8.3.8. I've tried out the pg_standby-version from PG8.4, but there is no difference in the result. So I can't understand what this return-code means, (and) I've never seen a file named 00000001.history. It definitely doesn't exist on my master and so my archive_command can't replicate to the slave. This is all content of 'backup_label' out of my base-backup: START WAL LOCATION: 0/AE000020 (file 0000000100000000000000AE) CHECKPOINT LOCATION: 0/AE000020 START TIME: 2009-10-25 14:36:25 CET LABEL: 25102009_1 I can't get information out of pg_standby.log, there is nothing in. That's the complete pg-log (debug-level 5): 2009-10-25 15:44:45 CET DEBUG: 00000: forked new backend, pid=1220 socket=1312 2009-10-25 15:44:45 CET LOCATION: BackendStartup, .\src\backend\postmaster\postmaster.c:2861 2009-10-25 15:44:45 CET LOG: 00000: database system was interrupted; last known up at 2009-10-25 14:36:25 CET 2009-10-25 15:44:45 CET LOCATION: StartupXLOG, .\src\backend\access\transam\xlog.c:4839 2009-10-25 15:44:45 CET LOG: 00000: starting archive recovery 2009-10-25 15:44:45 CET LOCATION: readRecoveryCommandFile, .\src\backend\access\transam\xlog.c:4377 2009-10-25 15:44:45 CET LOG: 00000: restore_command = 'pg_standby.exe -d -s 5 -t C:\pgsql.trigger.5442 w:\wal-archive %f %p %r 2>>pg_log\pg_standby.log' 2009-10-25 15:44:45 CET LOCATION: readRecoveryCommandFile, .\src\backend\access\transam\xlog.c:4423 2009-10-25 15:44:45 CET DEBUG: 00000: executing restore command "pg_standby.exe -d -s 5 -t C:\pgsql.trigger.5442 w:\wal-archive 00000001.history pg_xlog\RECOVERYHISTORY 000000000000000000000000 2>>pg_log\pg_standby.log" 2009-10-25 15:44:45 CET LOCATION: RestoreArchivedFile, .\src\backend\access\transam\xlog.c:2569 2009-10-25 15:44:45 CET LOG: 00000: loaded library "$libdir/plugins/plugin_debugger.dll" 2009-10-25 15:44:45 CET LOCATION: load_libraries, .\src\backend\utils\init\miscinit.c:1187 2009-10-25 15:44:45 CET FATAL: 57P03: the database system is starting up 2009-10-25 15:44:45 CET LOCATION: ProcessStartupPacket, .\src\backend\postmaster\postmaster.c:1648 2009-10-25 15:44:45 CET DEBUG: 00000: proc_exit(1) 2009-10-25 15:44:45 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:98 2009-10-25 15:44:45 CET DEBUG: 00000: shmem_exit(1) 2009-10-25 15:44:45 CET LOCATION: shmem_exit, .\src\backend\storage\ipc\ipc.c:164 2009-10-25 15:44:45 CET DEBUG: 00000: exit(1) 2009-10-25 15:44:45 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:116 2009-10-25 15:44:45 CET DEBUG: 00000: reaping dead processes 2009-10-25 15:44:45 CET LOCATION: reaper, .\src\backend\postmaster\postmaster.c:2093 2009-10-25 15:44:45 CET DEBUG: 00000: server process (PID 1220) exited with exit code 1 2009-10-25 15:44:45 CET LOCATION: LogChildExit, .\src\backend\postmaster\postmaster.c:2520 2009-10-25 15:44:45 CET FATAL: XX000: could not restore file "00000001.history" from archive: return code -1073741811 2009-10-25 15:44:45 CET LOCATION: RestoreArchivedFile, .\src\backend\access\transam\xlog.c:2639 2009-10-25 15:44:45 CET DEBUG: 00000: proc_exit(1) 2009-10-25 15:44:45 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:98 2009-10-25 15:44:45 CET DEBUG: 00000: shmem_exit(1) 2009-10-25 15:44:45 CET LOCATION: shmem_exit, .\src\backend\storage\ipc\ipc.c:164 2009-10-25 15:44:45 CET DEBUG: 00000: exit(1) 2009-10-25 15:44:45 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:116 2009-10-25 15:44:45 CET DEBUG: 00000: reaping dead processes 2009-10-25 15:44:45 CET LOCATION: reaper, .\src\backend\postmaster\postmaster.c:2093 2009-10-25 15:44:45 CET LOG: 00000: startup process (PID 3820) exited with exit code 1 2009-10-25 15:44:45 CET LOCATION: LogChildExit, .\src\backend\postmaster\postmaster.c:2520 2009-10-25 15:44:45 CET LOG: 00000: aborting startup due to startup process failure 2009-10-25 15:44:45 CET LOCATION: reaper, .\src\backend\postmaster\postmaster.c:2113 2009-10-25 15:44:45 CET DEBUG: 00000: proc_exit(1) 2009-10-25 15:44:45 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:98 2009-10-25 15:44:45 CET DEBUG: 00000: shmem_exit(1) 2009-10-25 15:44:45 CET LOCATION: shmem_exit, .\src\backend\storage\ipc\ipc.c:164 2009-10-25 15:44:45 CET DEBUG: 00000: exit(1) 2009-10-25 15:44:45 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:116 2009-10-25 15:44:46 CET DEBUG: 00000: logger shutting down 2009-10-25 15:44:46 CET LOCATION: SysLoggerMain, .\src\backend\postmaster\syslogger.c:435 2009-10-25 15:44:46 CET DEBUG: 00000: proc_exit(0) 2009-10-25 15:44:46 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:98 2009-10-25 15:44:46 CET DEBUG: 00000: shmem_exit(0) 2009-10-25 15:44:46 CET LOCATION: shmem_exit, .\src\backend\storage\ipc\ipc.c:164 2009-10-25 15:44:46 CET DEBUG: 00000: exit(0) 2009-10-25 15:44:46 CET LOCATION: proc_exit, .\src\backend\storage\ipc\ipc.c:116 thx a lot, murphy
