I followed the http://linuxsilo.net/articles/postgresql-pgpool.html to set up pgpool-ii replication.
When I detach and recover a node with these commands: # pcp_detach_node -d 240 127.0.0.1 9898 user pass 1 # pcp_recovery_node -d 240 127.0.0.1 9898 user pass 1 I can observer the following on node 1 in postgres logs - : 2009-12-23 06:03:15 SGT LOG: database system was interrupted; last known up at 2009-12-23 06:03:12 SGT 2009-12-23 06:03:15 SGT LOG: starting archive recovery 2009-12-23 06:03:15 SGT LOG: restore_command = '/usr/bin/scp db10:/var/lib/postgresql/8.3/main/pg_xlog_archive/%f %p' scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000002.history: No such file or directory 2009-12-23 06:03:16 SGT LOG: incomplete startup packet 2009-12-23 06:03:16 SGT FATAL: the database system is starting up 2009-12-23 06:03:17 SGT FATAL: the database system is starting up 2009-12-23 06:03:17 SGT LOG: restored log file "00000002000000000000005D" from archive 2009-12-23 06:03:17 SGT LOG: automatic recovery in progress 2009-12-23 06:03:17 SGT LOG: redo starts at 0/5D000068 2009-12-23 06:03:17 SGT FATAL: the database system is starting up 2009-12-23 06:03:18 SGT FATAL: the database system is starting up 2009-12-23 06:03:18 SGT FATAL: the database system is starting up 2009-12-23 06:03:19 SGT LOG: restored log file "00000002000000000000005E" from archive scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000002000000000000005F: No such file or directory 2009-12-23 06:03:19 SGT LOG: could not open file "pg_xlog/00000002000000000000005F" (log file 0, segment 95): No such file or directory 2009-12-23 06:03:19 SGT LOG: redo done at 0/5E000068 2009-12-23 06:03:19 SGT FATAL: the database system is starting up 2009-12-23 06:03:19 SGT FATAL: the database system is starting up 2009-12-23 06:03:20 SGT FATAL: the database system is starting up 2009-12-23 06:03:20 SGT LOG: restored log file "00000002000000000000005E" from archive 2009-12-23 06:03:20 SGT FATAL: the database system is starting up scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000003.history: No such file or directory 2009-12-23 06:03:20 SGT LOG: selected new timeline ID: 3 scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000002.history: No such file or directory 2009-12-23 06:03:20 SGT LOG: archive recovery complete 2009-12-23 06:03:20 SGT LOG: autovacuum launcher started 2009-12-23 06:03:20 SGT LOG: database system is ready to accept connections Because of these errors, recovery sometimes fails. How does postgres on the node which is recovered determines the %f files it needs to copy? -- Tomasz Chmielewski http://wpkg.org _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
