Hi,
I got this scenario:
master01
--> slave01 ---> slave02 -----> slave03 -------> slave04
As you can see, slave03 replicates from slave02 and slave04 from slave03.
I'm promoting slave03 into a master, and trying to make slave04 to be able to connect to its new master.
AS i'm using PostgreSQL 9.1, I need to manually copy the .history files from pg_xlog on slave03 to pg_xlog on slave04 (I don't need to copy the wal files as my archive_command does that).
When I promote slave03:
pg_ctl promote -D datadir
... it works fine!
Then, I restart postgres on slave04 with the new history file and the message that I get is:
FATAL: could not receive data from WAL stream: 00000000000400000001234 FATAL: requested WAL segment has already been removed
Why does that happen? I can't find 00000000000400000001234 even on the slave03(new master)! wal_keep_segments is 500.
Thanks
Patrick