[Pgpool-general] online recovery of primary is possible or not?
Alessandro Candini
candini at meeo.it
Mon Nov 22 14:49:40 UTC 2010
I've read here:
http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
that online recovery with streaming replication is possible.
But in the official doc it is said that only with standby it's possible to
perform online recovery
(http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#master_slave_mode)...who
is right?
I've tried to configure pgpool to perform an online recovery anyway, as
described in the first link, but without success. Unlike that tutorial I have
three separated machines which are primary, standby and pgpool.
Everything works fine but at the very last step, postgres on the ex-primary (now
standby) says:
LOG: entering standby mode
LOG: streaming replication successfully connected to primary
LOG: unexpected timeline ID 24 in log file 3, segment 60, offset 0
FATAL: terminating walreceiver process due to administrator command
LOG: unexpected timeline ID 24 in log file 3, segment 60, offset 0
What can I do?
More information about the Pgpool-general
mailing list