rendered paste bodypostgresql-8.3-main.log:
2011-05-01 21:51:35 EDT LOG: incomplete startup packet
2011-05-01 21:51:35 EDT LOG: received fast shutdown request
2011-05-01 21:51:35 EDT LOG: aborting any active transactions
2011-05-01 21:51:35 EDT LOG: autovacuum launcher shutting down
2011-05-01 21:51:35 EDT LOG: shutting down
2011-05-01 21:51:35 EDT LOG: database system is shut down
2011-05-01 21:52:46 EDT LOG: could not create IPv6 socket: Address family not supported by protocol
2011-05-01 21:52:46 EDT LOG: database system was interrupted; last known up at 2011-05-01 21:52:09 EDT
2011-05-01 21:52:46 EDT LOG: starting archive recovery
2011-05-01 21:52:46 EDT LOG: restore_command = '/usr/lib/postgresql/8.3/bin/pg_standby -w 0 -l -d -s 2 -t /tmp/pgsql.trigger /var/lib/postgresql/8.3/main/pg_xlog %f %p %r 2>>/var/log/postgresql/standby.log'
2011-05-01 21:52:46 EDT LOG: restored log file "0000000100000015000000B0.00000068.backup" from archive
2011-05-01 21:52:46 EDT LOG: restored log file "0000000100000015000000B0" from archive
2011-05-01 21:52:46 EDT LOG: automatic recovery in progress
2011-05-01 21:52:46 EDT LOG: redo starts at 15/B00000B0
2011-05-01 21:52:46 EDT LOG: restored log file "0000000100000015000000B1" from archive
2011-05-01 21:52:46 EDT LOG: unexpected pageaddr 15/A7000000 in log file 21, segment 177, offset 0
2011-05-01 21:52:46 EDT LOG: redo done at 15/B000B500
2011-05-01 21:52:46 EDT LOG: last completed transaction was at log time 2011-05-01 21:52:11.321963-04
2011-05-01 21:52:46 EDT LOG: restored log file "0000000100000015000000B0" from archive
2011-05-01 21:52:46 EDT LOG: selected new timeline ID: 2
2011-05-01 21:52:46 EDT LOG: incomplete startup packet
2011-05-01 21:52:46 EDT LOG: archive recovery complete
2011-05-01 21:52:47 EDT FATAL: the database system is starting up
2011-05-01 21:52:47 EDT FATAL: the database system is starting up
2011-05-01 21:52:48 EDT FATAL: the database system is starting up
2011-05-01 21:52:48 EDT FATAL: the database system is starting up
2011-05-01 21:52:49 EDT FATAL: the database system is starting up
2011-05-01 21:52:49 EDT FATAL: the database system is starting up
2011-05-01 21:52:50 EDT FATAL: the database system is starting up
2011-05-01 21:52:50 EDT FATAL: the database system is starting up
2011-05-01 21:52:51 EDT FATAL: the database system is starting up
2011-05-01 21:52:51 EDT FATAL: the database system is starting up
2011-05-01 21:52:52 EDT FATAL: the database system is starting up
2011-05-01 21:52:52 EDT LOG: incomplete startup packet
2011-05-01 21:52:53 EDT FATAL: the database system is starting up
2011-05-01 21:52:55 EDT FATAL: the database system is starting up
2011-05-01 21:52:55 EDT LOG: autovacuum launcher started
2011-05-01 21:52:55 EDT LOG: database system is ready to accept connections
standby.log:
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 00000001.history
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/00000001.history
Restoring to... : pg_xlog/RECOVERYHISTORY
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/00000001.history" "pg_xlog/RECOVERYHISTORY"
Keep archive history : 000000000000000000000000 and later
running restore : OK
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 0000000100000015000000B0.00000068.backup
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B0.00000068.backup
Restoring to... : pg_xlog/RECOVERYHISTORY
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B0.00000068.backup" "pg_xlog/RECOVERYHISTORY"
Keep archive history : 000000000000000000000000 and later
running restore : OK
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 0000000100000015000000B0
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B0
Restoring to... : pg_xlog/RECOVERYXLOG
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B0" "pg_xlog/RECOVERYXLOG"
Keep archive history : 000000000000000000000000 and later
running restore : OK
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 0000000100000015000000B1
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B1
Restoring to... : pg_xlog/RECOVERYXLOG
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B1" "pg_xlog/RECOVERYXLOG"
Keep archive history : 0000000100000015000000B0 and later
running restore : OK
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 0000000100000015000000B0
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B0
Restoring to... : pg_xlog/RECOVERYXLOG
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/0000000100000015000000B0" "pg_xlog/RECOVERYXLOG"
Keep archive history : 000000000000000000000000 and later
running restore : OK
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 00000002.history
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/00000002.history
Restoring to... : pg_xlog/RECOVERYHISTORY
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/00000002.history" "pg_xlog/RECOVERYHISTORY"
Keep archive history : 000000000000000000000000 and later
running restore : OK
Trigger file : /tmp/pgsql.trigger
Waiting for WAL file : 00000001.history
WAL file path : /var/lib/postgresql/8.3/main/pg_xlog/00000001.history
Restoring to... : pg_xlog/RECOVERYHISTORY
Sleep interval : 2 seconds
Max wait interval : 0 forever
Command for restore : ln -s -f "/var/lib/postgresql/8.3/main/pg_xlog/00000001.history" "pg_xlog/RECOVERYHISTORY"
Keep archive history : 000000000000000000000000 and later
running restore : OK